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

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 fileopen
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 dataget external data, select *.* as
filetypes (All) and the same wizard will open

--

Regards,

Peo Sjoblom


"dave glynn" wrote in message
...
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

Thanks Peo

Regards

Dave

"Peo Sjoblom" wrote:

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 fileopen
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 dataget external data, select *.* as
filetypes (All) and the same wizard will open

--

Regards,

Peo Sjoblom


"dave glynn" wrote in message
...
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