Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Loosing zeros in Excel 2003
I have a user who enters 1536000 in a cell. He hits the Enter key and the
value in the cell shows 15360. Excel drops two of the zeros. If he puts the commas in the correct place he gets 1,536,000. What needs to be changed? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Loosing zeros in Excel 2003
Tools|options|edit tab|uncheck that fixed decimal places box
bsach wrote: I have a user who enters 1536000 in a cell. He hits the Enter key and the value in the cell shows 15360. Excel drops two of the zeros. If he puts the commas in the correct place he gets 1,536,000. What needs to be changed? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
Excel Re-calculation 2000 compared to 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 crashes loading excel files created Excel 2000 | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |