Monday, June 22, 2009

Padding out a cell with leading zeros in Excel

http://www.mrexcel.com/archive/General/14898.html

=REPT(0,8-LEN(A1))&A1

Or you can use the Format->Custom and enter 0000

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)