ExcelBanter - When I input a number it is being multiplied 10,000

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

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

- - When I input a number it is being multiplied 10,000 (https://www.excelbanter.com/excel-discussion-misc-queries/137015-when-i-input-number-being-multiplied-10-000-a.html)

Joe

When I input a number it is being multiplied 10,000

How can I fix this? What is going on?

JE McGimpsey

When I input a number it is being multiplied 10,000

One possibility:

Go to Tools/Options/Preferences/Edit and uncheck the

Fixed decimal places -4

checkbox.

In article ,
Joe wrote:

How can I fix this? What is going on?

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