Home |
Search |
Today's Posts |
#1
|
|||
|
|||
My excel2000 divide numbers per 10 why?
In every old or new sheet and cell with general or number format when i type
a number, excel divide it per 10. For example when i type 80 after enter, i see 8 in that cell. |
#2
|
|||
|
|||
Use Tools | Options; open the Edit tab; uncheck the box called Fixed
Decimal.... best wishes -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "mohammad" wrote in message ... In every old or new sheet and cell with general or number format when i type a number, excel divide it per 10. For example when i type 80 after enter, i see 8 in that cell. |
#3
|
|||
|
|||
Tools|Options and look on the Edit tab. Uncheck the fourth item down
(Fixed decimal Places) Jerry mohammad wrote: In every old or new sheet and cell with general or number format when i type a number, excel divide it per 10. For example when i type 80 after enter, i see 8 in that cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
I enter numbers and they are stored as text | Excel Discussion (Misc queries) | |||
How do I take two columns of sequential numbers and insert spaces | Excel Discussion (Misc queries) | |||
adding only positive numbers | Excel Discussion (Misc queries) | |||
Negative Numbers | Excel Discussion (Misc queries) |