Leading zero's
Leading zero's
(OP)
I need to pu serial numbers into a spread sheet complete with the leading zero's. I need 00001234 not 1234.
I've done this in the past but can not remember how.
Can any one help please?
John
ps it's excel 97.
I've done this in the past but can not remember how.
Can any one help please?
John
ps it's excel 97.





RE: Leading zero's
RE: Leading zero's
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Leading zero's
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
Steam Engine enthusiasts: www.essexsteam.co.uk
RE: Leading zero's
electricpete that worked but caused a problem later in the process, but thanks for the suggestion
John
RE: Leading zero's
RE: Leading zero's
Format as 00000000
----------------------------------
Hope this helps.
----------------------------------
maybe only a drafter
but the best user at this company!