ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   New Excel doc automatically divides any number typed by ten - Need (https://www.excelbanter.com/setting-up-configuration-excel/168413-new-excel-doc-automatically-divides-any-number-typed-ten-need.html)

She_Wizard

New Excel doc automatically divides any number typed by ten - Need
 
I have Ofc 2003. When I open a new Excel doc, any number I type in
automatically is divided by ten (for instance, if I type in 123 and hit
enter, it becomes 12.3). I can not find a default formatting feature to
override this. The software was installed by our company IT Dept, and they
assure me the installation is correct. Any ideas?

Gary''s Student

New Excel doc automatically divides any number typed by ten - Need
 
Tools Options General clear fixed decimal
--
Gary''s Student - gsnu200759


All times are GMT +1. The time now is 02:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com