Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Leading zero's 1

Status
Not open for further replies.

Blackcountryman

Electrical
Joined
Jul 14, 2005
Messages
72
Location
GB
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.
 
Format->Cells and choose "Custom". Type as many zeros as you want to have places.
 
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.
 
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:
 
thanks handleman that worked.

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

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

Format as 00000000

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

maybe only a drafter
but the best user at this company!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top