Digits Truncated: Enter 3 Million, Cell displays 30,000?

[MJSlattery]

I am entering numbers into a cell that is not being influenced by an active macro. Formatted for number with no decimals. The last one or two zeros from the entry are being truncated. When I enter 3,700,000 the cell will lose the last two zeros and display 37,000?

I can copy the same cell from another worksheet and it will accept it and the number remains complete, but if I try and re-enter another number into it the truncation begins again. The cell is being utilized in a calculation, but it does not have a formula in it, it's just a number value.

Strangest thing I have ever seen in excel.

Thanks for you suggestions and ideas about WTF is going on?

Michael

[shg]

Excel Options > Advanced, Editing Options, untick Automatically insert a decimal point

[MJSlattery]

Thanks! Michael