ExcelBanter - Loosing zeros in Excel 2003

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - Loosing zeros in Excel 2003 (https://www.excelbanter.com/setting-up-configuration-excel/79048-loosing-zeros-excel-2003-a.html)

bsach

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?

Dave Peterson

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

All times are GMT +1. The time now is 03:45 PM.