Leading digits

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got an Excel workbook that contains many license numbers and I need to
format the column so that if a license number has several 0s in front, they
aren't automatically truncated by Excel. I tried general, number, and text
formats but they truncate leading 0s. Any ideas? Thanks.
 
Hi Brent
Put an apostrophe in front of the number, eg.

'00045879
this will enforce the zeros to be displayed


HTH
Michael
 
Custom form at of

000000

or however many

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Custom form at of

000000

or however many

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Thanks guys, I'll try those ideas. I forgot about that apostope. cool. And
the customer sounds like a good way too, but I am curious, how do I do that
if the amount of leading 0s may be different for different numbers? Thanks
again guys.
 
You could put the following into a cell
'000

then add that to your licence number using &

i.e. =A15&B16
 

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 0s and Col Formatting 2
Formatting column 1
Format Cols 2
how do i eliminate leading 0 in a text cell 2
how do I eliminate leading "0s" in an alpha numeric cell 1
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Need 7 digit number with differnt number of leading zeros 10
How do I stop Excel from dropping leading zeros? 9

Back
Top