Leading digits
 

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
--
Michael Mitchelson


"Brent E" wrote:

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.

Custom form at of

000000

or however many

--

HTH

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


"Brent E" wrote in message
...
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.

Custom form at of

000000

or however many

--

HTH

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


"Brent E" wrote in message
...
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.

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.

"Michael" wrote:

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

'00045879
this will enforce the zeros to be displayed


HTH
Michael
--
Michael Mitchelson


"Brent E" wrote:

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.

You could put the following into a cell
'000

then add that to your licence number using &

i.e. =A15&B16

"Brent E" wrote:

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.