When using general format for a cell, numbers appear with decimals

S

Simmian

I'm working in a new workbook.

When I type in a number like 535, it shows up in the cell as 5.35

The format of the cell is General and not number. Even the example that
shows up when looking at the cell format shows the decimal. This shouldn't
be happening. Any suggestions?
 
N

Niek Otten

Tools>Options, Edit tab, uncheck Fixed decimal

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| I'm working in a new workbook.
|
| When I type in a number like 535, it shows up in the cell as 5.35
|
| The format of the cell is General and not number. Even the example that
| shows up when looking at the cell format shows the decimal. This shouldn't
| be happening. Any suggestions?
 
Top