Hi
either preformat the cell as 'Text' or enter this value with a leading
apostrophe. e.g.
'4/5
--
Regards
Frank Kabel
Frankfurt, Germany
"kei" schrieb im Newsbeitrag
...
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!!
|