Show leading zeros.

  • Thread starter Thread starter panaga
  • Start date Start date
Format the cell with a custom format similar to 0000. This will always
display the number as having 4 digits with leading zero(s).
 
The only way I know of is to force the entry to be seen as text.

Precede your number with an apostrophe
Ex. '001234

HTH,
Paul
 
Ok. That wasn't the only way I knew of...I just wasn't thinking straight
when I replied.

--
 
hi
to add...
formatting will show leading zeros on the screen but not in the formula bar.
formatting changes the way data looks, not the data. the data will not export
with leading zeros. to do that it must be formatted as text.

regards
FSt1
 
Hi,

You can do this many ways, some already mentioned:

1. Format the cell to Text, then type the numbers in with leading 0's
2. Start the entry with an apostrophy '0001234
3. Format the cell to Custom 00000 adding as many zeros as you want to show.
4. =RIGHT("00000"&A1,5) this will create a cell which packs leading 0's up
to five characters in all.

With numbers 1, 2, 4 above the cell actually contains the digits, with #3 it
is strictly a format, the cell does not contain the leading 0's.
 
You must log in or register to reply here.

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

Leading Zero 11
Leading Zero as value not appearance 2
Eliminate leading numbers - Excel 2007 2
How do I stop Excel from dropping leading zeros? 9
Replacing cell numbers but leaving leading zero 1
Another Leading Zero Question 7
Array formula to Identify Leading Zeros. 2
Need 7 digit number with differnt number of leading zeros 10

Back
Top