Text Format
Change the name of the file to a txt file.
Then open the file and the open text files Wizard will be
openned
then you select delimited by
select comma as the delimiter
then you select the column with your data and select TEXT
your data will not be converted to date
Francisco Mariscal
-----Original Message-----
Hi,
I have a csv file with values like "01-03-01", and when i
open this file in Excel this value is automatically
converted into Date format. How to avoid this?.
i want the text to just displayed as "01-03-01" when the
file is opened in excel without getting converted!. is
there a way to do this?
thanks,
Shiv
.
|