Thread: Text Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shivakumar shivakumar is offline
external usenet poster
 
Posts: 2
Default Text Format

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