Thread: Leading digits
View Single Post
  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

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.