Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I keep a worksheet from disappearing? | Excel Discussion (Misc queries) | |||
Add-Ins Disappearing? | Excel Discussion (Misc queries) | |||
Disappearing tabs | Excel Discussion (Misc queries) | |||
Disappearing cells | Excel Discussion (Misc queries) | |||
Disappearing Attachments | Excel Discussion (Misc queries) |