keeps converting text to date
Rename the .csv file to .txt and when you use file|open, you'll see the text to
columns wizard.
You'll be able to specify that this field is text.
Or keep the .csv file extension and use:
Data|import external data|import data (xl2003 menus)
You'll see that same text to columns wizard.
Meaghan wrote:
I have a csv file that changes the text string "2-99" in to "Feb-99". I have
changed the cell formatting and auto-correct to override this, however when I
save the file it wipes out the change -- when I reopen the file again it's
back to "Feb-99". No matter how I format the cells when the file is open,
when I save it the dialog box tells me some features aren't compatible and
changes "2-99" in to "Feb-99." How can I correct this? Thanks!
--
Dave Peterson
|