Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get my Excel not to convert everything to date format?
I tried to enter the following data into my Excel 2003:
34.08 1,813.94 1,882.09 207.33 4,175.63 4,590.29 284.25 5,019.79 5,588.29 0.00 296.97 296.97 5.03 30.17 40.23 And the result was: aug.34 1,813.94 1,882.09 207.33 4,175.63 4,590.29 284.25 5,019.79 5,588.29 0.00 296.97 296.97 03.máj 30.17 40.23 Why is Excel converting my data into dates? And 34th August? You must be kidding! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert date from text format to date format | Excel Discussion (Misc queries) | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
Excel 2000 worksheet where I want to convert date format | Excel Discussion (Misc queries) | |||
Date format not correct when you convert a CSV text file in Excel | Excel Discussion (Misc queries) | |||
How can I convert a date format to an ISO week format (in EXCEL)? | Excel Discussion (Misc queries) |