![]() |
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. |
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. |
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. |
All times are GMT +1. The time now is 06:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com