All number inputs are divided by 100 ?

Guest · Mar 23, 2006

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

Dave Peterson · Mar 23, 2006

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

Guest · Mar 24, 2006

Pull-down:

Tools > Optioms > Edit and clear the fixed decimal check box.

Number entered in cell getting always divided by 100 !	5	May 10, 2008
Number entries are automatically divided by 100 - Excel 2003	1	Mar 3, 2011
I want to link a cell in the macro	1	Apr 9, 2007
Number automatically divided by 100, why?	4	Feb 16, 2009
default format for Excel numbers	2	Jun 14, 2009
all numbers are divided by 10	1	Sep 7, 2004
Division as a %	2	Nov 19, 2011
I don't need the actual value but what is shown	2	Oct 28, 2009

Ask a Question