| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering numbers - doesn't work right
I need help! When I enter numbers, like "-2" or "1", they become "-0.02" and
"0.01". I have no idea why it's doing that. I've looked under "format cells" but I can't figure out what's wrong. Help me please! Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering numbers - doesn't work right
You have the 'fixed decimal' setting turned on. You should see
'Fix" in the bottom right corner of the Excel screen. To turn this off, go to the Tools menu, choose Options, then the Edit tab. There, uncheck "Fixed decimal". "Zzilly14" wrote in message ... I need help! When I enter numbers, like "-2" or "1", they become "-0.02" and "0.01". I have no idea why it's doing that. I've looked under "format cells" but I can't figure out what's wrong. Help me please! Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering numbers - doesn't work right
Tools|options|edit tab|uncheck fixed decimal places
Zzilly14 wrote: I need help! When I enter numbers, like "-2" or "1", they become "-0.02" and "0.01". I have no idea why it's doing that. I've looked under "format cells" but I can't figure out what's wrong. Help me please! Thanks! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert numbers that have hidden Quotation Mark Embedded | Excel Discussion (Misc queries) | |||
| create self-generating numbers with letters and numbers | Excel Discussion (Misc queries) | |||
| text and numbers same cell and formulas still work (like lotus) | Excel Worksheet Functions | |||
| How can I work with more than 15 numbers | Excel Discussion (Misc queries) | |||
| Entering More than 15 numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
