Leading decimal and zeros in formating numbers

  • Thread starter Thread starter DLJames
  • Start date Start date
D

DLJames

All the sudden my worksheet started adding a decimal and 10 zeros to my
number entries. I've tried to format the cell/column again, but it won't
change. What have I done and how do I fix it?
 
That fixed it! Thank you! Now the only question left, is how did that box
get checked in the first place? One minute I could enter just fine and then
later it was all crazy with zeros! Thank you again for your help. Sanity is
restored!
 
Two ways to get that enabled.

1. User checked it.

2. VBA code checked it.


Gord Dibben MS Excel MVP
 

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

decimal places and leading zeros 2
Excel 2007 adding a column of negative and positive number 2
Zeros after the decimal 7
Leading Zero in Hexadecimal? 5
Leading Zero 11
How to retain decimal zeroes? 5
Formatting zeros as dashes 4
Fixed Decimals in Excel 2007 4

Back
Top