cell format

  • Thread starter Thread starter Marinus van Holst
  • Start date Start date
M

Marinus van Holst

Excel 2000, Windows XP

I format a cell as, number, decimal places 4
I enter:
1.0, 1.1, 1.12 and I get as expected 1.0000, 1.1000, 1.1200
but when I enter 1.123 I get 1123.0000

It is not very difficult to overcome this aberration: =1.0 + 0.123 works
perfectly. The results of any calculations are also correctly displayed.

What to do to enter numbers as one may expect.

Marinus van Holst.
 
Just a guess...

What's your decimal point on your system?

Some Europeans use a comma for the decimal point.

You can check under control panel|regional settings.
 
Back
Top