Disappearing numbers
 

I have a user that is using a spreadsheet. When he copies and pastes a
number into the cells it is fine. When he types a number into the same cell
the last 2 numbers disappear and will only show when you set the decimal
places to 2.

The cells are formatted as a numeric with 0 decimal places.

TIA
--
Cyberwolf
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf

Disappearing numbers
 

Try ToolsOptionsEdit tab, uncheck Fixed decimal

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Cyberwolf" wrote in message ...
|I have a user that is using a spreadsheet. When he copies and pastes a
| number into the cells it is fine. When he types a number into the same cell
| the last 2 numbers disappear and will only show when you set the decimal
| places to 2.
|
| The cells are formatted as a numeric with 0 decimal places.
|
| TIA
| --
| Cyberwolf
| Finder of Paths, Hunter of Prey
| Ghost of the Night, Shadow of Day
| The Wolf