Leading digits

B

Brent E

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

Michael

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

'00045879
this will enforce the zeros to be displayed


HTH
Michael
 
B

Bob Phillips

Custom form at of

000000

or however many

--

HTH

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

Bob Phillips

Custom form at of

000000

or however many

--

HTH

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

Brent E

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

Kev Joy

You could put the following into a cell
'000

then add that to your licence number using &

i.e. =A15&B16
 
Top