| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I stop Excel from changing simple numbers to their 1/100th.
I'm working with the latest service pack of Excel 2000.
Every number I enter into any blank cell becomes that number's 100th decimal value. For example, typing "2" in a cell results in "0.02" when I leave the cell. This did not used to happen, but I don't know what I did to make it happen, nor what to do to stop it from happening. CC |
|
#2
|
|||
|
|||
|
hi
goto 'Tools - Options - Edit' and uncheck 'Fixed decimals' -- Regards Frank Kabel Frankfurt, Germany Chris C wrote: I'm working with the latest service pack of Excel 2000. Every number I enter into any blank cell becomes that number's 100th decimal value. For example, typing "2" in a cell results in "0.02" when I leave the cell. This did not used to happen, but I don't know what I did to make it happen, nor what to do to stop it from happening. CC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel converts Mapped drive to UNC - How to stop? | Links and Linking in Excel | |||
| Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
| How can I stop Excel from displaying rounded numbers? Credit car. | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
Linear Mode
