Leading digits

[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.

 

[Guest]

Hi Brent
Put an apostrophe in front of the number, eg.

'00045879
this will enforce the zeros to be displayed


HTH
Michael

 

[Bob Phillips]

Custom form at of

000000

or however many

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

Custom form at of

000000

or however many

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

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.

 

[Guest]

You could put the following into a cell
'000

then add that to your licence number using &

i.e. =A15&B16