Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel automatically changes numbers like1989to19.89 why? Help!
I use excel quite a bit. It has always been great, but recently, and without
any intervantion on my part, in excel 2007 the numbers I type are automatically changed from say 1989 to 19.89. It seems only to allow two digit numbers and puts all extra numbers after the the decimal point - e.g 27898, is changed to 27.898. This is really a pain!! I have not made changes to the default format and cannot find a way to put it back to keeping the numbers the same as they are when I type them in. I can change the numbers by turning them into text and then back into numbers, but it is ridiculous to have to keep on doing this! Much of my work includes examining historical data - including year dates - so changing 2009 to 20.09 is not very helpful!! Can anyone help solve this problem? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO AUTOMATICALLY GENERATE NUMBERS IN EXCEL | Excel Discussion (Misc queries) | |||
Assigning invoice numbers automatically in excel? | Excel Worksheet Functions | |||
How do I prevent excel from automatically changing my numbers? | Excel Discussion (Misc queries) | |||
Excel:a column of numbers,I want the highest shown automatically? | Excel Discussion (Misc queries) | |||
Excel Changing Numbers Automatically | Excel Discussion (Misc queries) |