Welcome Guest
Log In | Register )
You last visited December 4, 2016, 1:15 pm
All times shown are
Eastern Time (GMT-5:00)

Excel number Format

Topic closed. Posted 11 years ago. No replies.

Page 1 of 1
PrintE-mailLink
Avatar
Central Pa.
United States
Member #4076
March 19, 2004
32 Posts
Offline
Posted: February 6, 2006, 12:33 am - IP Logged

Ok have seen on many posts that members are having trouble with zeros in excel so here’s a format that will work for you. highlight the column or row you want Leading zeros to appear

 

 Go to format /cells/number/custom/ then depending if you want leading zeros to appear on the pick 3 or pick 4 or any other combination just go to the “0” in custom and click on it then add two more “0”s for the pick3 or add three more zeros for the pick 4 then click “ok”  that’s all there is to it

 

Good luck

 

Also if you use countif or other formulas and you don’t want to see the zeros all over the spreadsheet try this

 

Click on the column or row you want to format

 

Go to format/cells/number/custom/ then type the following in “0;-0;;@” then click ok..All the zeros will disappear.sure makes reading your spreadsheet a lot easier

 

Good luck

 
Bob