July 8, 2008 by tech guysFunction to add leading zero to number =TEXT(B2,”0#”) Category: Excel/VBA Showcase Your Agency Give your agency, business, or brand the sharp image it deserves with Mai Reach theme from BizBudding. Buy Mai Reach Now About tech guys Previous Post:SQL for Weighted Survey Results Next Post:IP location lookup