Date issues

[Ray Crump]

Hi Chandoo,

Trying to convert these dates and remove the comma from a .csv download that occurs every fortnight, doesn’t matter what I do from line 32 down I can only change it manually.

Example Apr 02, 2024 to either 02/04/2024 or 2nd April 2024

45401.00​	19 April 2024​
Apr 02, 2024	Apr 02, 2024
Apr 02, 2024	Apr 02, 2024
Apr 04, 2024	Apr 04, 2024
Apr 04, 2024	Apr 04, 2024
Apr 04, 2024	Apr 04, 2024
Apr 04, 2024	Apr 04, 2024
Apr 04, 2024	Apr 04, 2024
Apr 04, 2024	Apr 04, 2024
Apr 05, 2024	Apr 05, 2024
Apr 05, 2024	Apr 05, 2024
Apr 08, 2024	Apr 08, 2024
Apr 09, 2024	Apr 09, 2024

 

[vletm]

Ray Crump​

Could You send a sample .csv-file instead?
Is there any known reason, why row 31 is different than row 32?

 

[Ray Crump]

rows 1 to 31 I was trying to complete manually, I havnt come across a cell where you can't change the date format. Line 32 and down are the dates I am trying to convert, I had a reply to use the formula =IF(ISNUMBER(A2),A2, DATEVALUE(A2)), however that just converts lines up to 31 and then returns a error @ line 32. I don't think it is because it is a .csv file. It is like it is hard coded when it is exported from the programme. Really stumped on this one

 

[p45cal]

Could You send a sample .csv-file instead?

This is the best route to take.