View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Meaghan Meaghan is offline
external usenet poster
 
Posts: 3
Default keeps converting text to date

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!