numbers displayed wrong

Richard van Rijsbergen · Jul 15, 2009

When i type for example 22 in my excel sheet it is displayed as 0,22
This is also when i open a new empty sheet/workbook.

Bob Phillips · Jul 15, 2009

Goto Tools>Options>Edit and uncheck Fixed Decimal Places

NBVC · Jul 15, 2009

Go to Tools|Options and in the Edit tab, uncheck the Fixed Decima
option

Richard van Rijsbergen · Jul 15, 2009

It works. Thnx

Bob Phillips said:
Goto Tools>Options>Edit and uncheck Fixed Decimal Places

--
__________________________________
HTH

Bob