Exporting text date in CSV

[billy1989]

Hi guys - I have the following formula set up to give me the date and month of a year

=IF(A5="","",LEFT(TEXT(A5,"dd/mm"),5))

So it will show the date and month eg 01/07. But when I export to a CSV, it saves as 01-Jul - how can I stop it from doing this? It's driving me nuts!

 

[Joe4]

The LEFT function serves no purpose. This should be fine:

=IF(A5="","",TEXT(A5,"dd/mm"))

When you look at it before exporting does it look fine/correct?

If it does, then it actually is most likely working, and the mistake you are probably making is trying to view a CSV in Excel.
If you truly want to see what is in a CSV file, NEVER use Excel to view it! Excel will perform its own conversions on the data automatically upon opening it.
View the CSV file in a Text Editor, like NotePad, and you will see what is really in the CSV file.

 

[billy1989]

The LEFT function serves no purpose. This should be fine:

=IF(A5="","",TEXT(A5,"dd/mm"))

When you look at it before exporting does it look fine/correct?

If it does, then it actually is most likely working, and the mistake you are probably making is trying to view a CSV in Excel.
If you truly want to see what is in a CSV file, NEVER use Excel to view it! Excel will perform its own conversions on the data automatically upon opening it.
View the CSV file in a Text Editor, like NotePad, and you will see what is really in the CSV file.

Whoops, had been looking at formulae for so long I missed that I could have removed that!

Before export it's fine, but I need to go in and remove some columns after export.

 

[Joe4]

Before export it's fine, but I need to go in and remove some columns after export.

Why not do that BEFORE you export?