Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unnecessary conversion
Hi All,
I have a normal XL file generated by an application as output. There are cells in it containing decimal numbers stored as text, e.g. "5.2". When Opening this file XL converts strings recognizable as a date to dates, like 2007/5/2. What can I do to keep the original string "5.2" or convert it to a real decimal number? Regards, Stefi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion of Multiple Currencies into USD and CHF (Swiss Francs) | Excel Discussion (Misc queries) | |||
ascii conversion | Excel Discussion (Misc queries) | |||
Excel file conversion | Excel Discussion (Misc queries) | |||
how to maintain hyperlink in excel to pdf conversion | New Users to Excel | |||
Curency Conversion Dilemma | Excel Worksheet Functions |