fractions turn into dates when pasting in excel 2003
when pasting data from a web page [ Metric/Inch Conversion] into excel,
fractions turn into dates. The same chart pastes perfectly into word but
wont copy from word into excel with out the fractions changing into dates.
and I cannot change the dates back to fractions ie 1/64 turns into Jan-64
which converts to 23377
Thanking you in advance
|