Forum Discussion
How To Prevent Excel From Converting a Comma Delimited Field Into A Number Type Field
I have a report that is exported from a system into a .csv file format. There is a field in the report that contains values separated by commas after every seven characters. For some reason, when t...
Hi JBLT-77
when you open CSV files, Excel does not ask for any formatting etc.
The easiest way around this is to rename the file from filename.csv into filename.txt
When you open it now from within Excel, the Text-import-wizard gets launched, and in the third step you can define the format for each column. Which should be text in your case.