leading zeros in excel

  • Thread starter Thread starter Guest
  • Start date Start date
If that is for a US zip code, they really should be
formatted as text then they can also be consistent with
zip+4 codes as well, and with codes used in other
countries as well. Format as text is best, or precede
with a single quote.

If they aren't going to be treated arithmetically then they
probably should not be treated as numbers. Credit cards
for instance are usually 16 digits and Excel only provides
for 15 digits so they have to be entered as text or you
end up with bad data.
 

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

How to stop Excel from automatically truncating leading zeros 2
Leading Zero 11
Another Leading Zero Question 7
Replacing cell numbers but leaving leading zero 1
Need 7 digit number with differnt number of leading zeros 10
Stop automatically removing leading zeros? 2
How do I stop Excel from dropping leading zeros? 9
Leading Zero as value not appearance 2

Back
Top