Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007 numbers truncated
I open a new sheet and tried to place a four digit number in the box. the
moment I go to another box the number reverts to the first two digits. Can you tell me how to stop that from happening. I need to four digit numbering and haven't been able to set up the proper numbers???? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007 numbers truncated
Click the round "Office" Icon at the left upper corner Excel Options
'Advanced' and in the 'Edit options' cancel the selection from 'Add Fixed Decimal Automatically...' Micky "AQUICKPRINT" wrote: I open a new sheet and tried to place a four digit number in the box. the moment I go to another box the number reverts to the first two digits. Can you tell me how to stop that from happening. I need to four digit numbering and haven't been able to set up the proper numbers???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
picture is too large and will be truncated - Excel 2007 | Excel Discussion (Misc queries) | |||
Why are large reports truncated in Excel? | Excel Discussion (Misc queries) | |||
MS query returns truncated data to Excel | Excel Discussion (Misc queries) | |||
How do I recover text that was truncated/ deleted in Excel? | Excel Discussion (Misc queries) | |||
Excel 2007 pivot table data is truncated | Excel Discussion (Misc queries) |