i have fields that are formatted for text that randomly convert t.

D

dave glynn

i have fields that in the original spreadsheets are formatted as "text" that
appear as date when ultimately converted to a .csv. This happens purely
randomly and all the sheets and fields in which they appear have been
formatted as "text". In spite of this certain numbers appear as "date"
formatted in the csv file. any ideas.

Thanks

Dave
 
P

Peo Sjoblom

The CSV don't change any formatting, it's when you import it into Excel it
changes, you can rename the file to a TXT extension, open it from file>open
and the text import wizard will open, if you click next twice you can select
text under column data format
or you can use the CSV format and do data>get external data, select *.* as
filetypes (All) and the same wizard will open
 
D

dave glynn

Thanks Peo

Regards

Dave

Peo Sjoblom said:
The CSV don't change any formatting, it's when you import it into Excel it
changes, you can rename the file to a TXT extension, open it from file>open
and the text import wizard will open, if you click next twice you can select
text under column data format
or you can use the CSV format and do data>get external data, select *.* as
filetypes (All) and the same wizard will open

--

Regards,

Peo Sjoblom
Click to expand...
 
Top