Leading zero's 1

[Blackcountryman]

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.

 

[handleman]

Format->Cells and choose "Custom". Type as many zeros as you want to have places.

 

[electricpete]

Try putting a single quote in front of the s/n. Then it will treat it as text and display exactly what you typed.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[johnwm]

Format->Cells and choose "Text". All values, including numbers with or without leading zeroes, are treated as literal text

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting

Steam Engine enthusiasts:

http://www.essexsteam.co.uk

 

[Blackcountryman]

thanks handleman that worked.

electricpete that worked but caused a problem later in the process, but thanks for the suggestion

John

 

[rave8088]

On Column or Row or Cell : Right click ->Format Cells ->Number -> Custom -> On type ENTER # of LEADING ZEROS YOU WANT....gOOD LUCK!

 

[onlyadrafter]

Hello,

Format as 00000000

----------------------------------
Hope this helps.
----------------------------------

maybe only a drafter
but the best user at this company!