CSV file format changes format on opening

[BensTooCool]

Hi,

I have a dataset that I currently save as a csv file, one column in particular is causing me a bit of a headache. In column C I have a first line of an address field with a number of addresses that have just a flat number such as 4422.

When I save the file in csv format via a VBA macro the formatting of this field is fine but if I then close the file and reopen it then those values in column C with the flat numbers has been converted to a date column.

How can I prevent this from happening and keep that column as a text column??

Thanks,

Ben

 

[Joe4]

There is nothing wrong with the CSV file. The issue is that you are trying to use Excel to view it!
You should NEVER use Excel to view the contents of CSV files, as Excel does its own conversions on the data when you open it, so you do not see the data as it really exists in the CSV file.
You should use a Text Editor look NotePad to view the CSV file if you want to see what the data in it really looks like.