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
Central Pa.
United States
Member #4076
March 19, 2004
32 Posts
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