Loosing zeros in Excel 2003

B

bsach

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Relevant user should see only his data 0
Word macro that can call cells out of Excel for a find and replace 0
Linking data in MS Word into Excel 5
VB Script reference cells for in current table? 1
VBA word change keys 0
Excel 2010 for PC doesnt work on Excel Mac 2011. 11
Force zeros in Excel 2007 when cells blank and keep commas for thousands 0

Top