ExcelBanter - leading zeros

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - leading zeros (https://www.excelbanter.com/excel-discussion-misc-queries/237695-leading-zeros.html)

Dave[_11_]

leading zeros

Hi All,

I have an issue with formating cells. I have a permit number that has
leading zeros sometimes, so I must display them when entered. I have
tried 0?-??????? and 0#-####### but no luck. Heres is what my permit
number look
01-2345678 & 02-8765432.

thanks,

Dave

Jim Thomlinson

leading zeros

You are soooo close...

00-0000000
--
HTH...

Jim Thomlinson

"Dave" wrote:

Hi All,

I have an issue with formating cells. I have a permit number that has
leading zeros sometimes, so I must display them when entered. I have
tried 0?-??????? and 0#-####### but no luck. Heres is what my permit
number look
01-2345678 & 02-8765432.

thanks,

Dave

All times are GMT +1. The time now is 03:35 PM.