Annoying format when typing in numbers in the spreadsheet

[aleksnhh]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel When I type in 1 or 2 in the spreadsheet, this is shown as 0,1 and 0,2 and if I type in 22 this is shown automatically as 2,2. Have to punch in 22, comma and zero to get the correct number 22.

Do anyone know where i turn of this option?

 

[Phillip Jones, C.E.T.]

Select desired row, column, or cells
click on Format menu click cells.
when window opens choose, numbers. set numbering format as desired.
If none to suit choose custom and type in your own.

 

[CyberTaz]

Go to Excel> Preferences> Edit, clear the check on 'Display this number of
decimal places'.

HTH |:>)
Bob Jones
[MVP] Office:Mac