ExcelBanter - Why does Excel auto-divide numerical inputs by 100?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Why does Excel auto-divide numerical inputs by 100? (https://www.excelbanter.com/excel-discussion-misc-queries/221352-why-does-excel-auto-divide-numerical-inputs-100-a.html)

CurtisB

Why does Excel auto-divide numerical inputs by 100?

For some reason, Excel started dividing all my integer inputs by 100? Does
anyone know why this is happening?

Chip Pearson

Why does Excel auto-divide numerical inputs by 100?

Go to the Tools menu, choose Options, then the Edit tab. There,
uncheck the "Fixed Decimal" setting. This setting is useful if you
want to enter a large number of dollars and cents values but don't
want to type the decimal point.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Tue, 17 Feb 2009 13:16:25 -0800, CurtisB
wrote:

For some reason, Excel started dividing all my integer inputs by 100? Does
anyone know why this is happening?

David Biddulph[_2_]

Why does Excel auto-divide numerical inputs by 100?

Tools/ Options/ Edit
Unset "Fixed decimal places"
--
David Biddulph

CurtisB wrote:
For some reason, Excel started dividing all my integer inputs by 100?
Does anyone know why this is happening?

CurtisB

Why does Excel auto-divide numerical inputs by 100?

.... Because the ToolsOptionsEditFixed Decimal Places check box was checked!

"CurtisB" wrote:

For some reason, Excel started dividing all my integer inputs by 100? Does
anyone know why this is happening?

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