ExcelBanter - All number inputs are divided by 100 ?

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - All number inputs are divided by 100 ? (https://www.excelbanter.com/setting-up-configuration-excel/79305-all-number-inputs-divided-100-a.html)

davor

All number inputs are divided by 100 ?

All number inputs are automatically divided by 100 (example: input in cell
12 result: 0.12 in cell)?!

Dave Peterson

All number inputs are divided by 100 ?

Tools|options|edit tab|uncheck that fixed decimal places box

davor wrote:

All number inputs are automatically divided by 100 (example: input in cell
12 result: 0.12 in cell)?!

--

Dave Peterson

Gary''s Student

All number inputs are divided by 100 ?

Pull-down:

Tools Optioms Edit and clear the fixed decimal check box.
--
Gary's Student

"davor" wrote:

All number inputs are automatically divided by 100 (example: input in cell
12 result: 0.12 in cell)?!

All times are GMT +1. The time now is 05:44 AM.