View Single Post
  #1   Report Post  
kei
 
Posts: n/a
Default prevent 4/5 in a cell automatically transfer to a date format

I have a .csv file with some number like 4/5 (x/y), but when open in Excel,
it automatically transfer to a date, how to prevent this and preserve the
original format (x/y)? (In fact, even I type 4/5 in a cell, it will
automatically change to a Date, how to prevent it?)
I'm using Excel 2002 version

Thx!!