Left Padding Zeros in Excel
Here’s a quick equation to use in Excel if you’re trying to pad a number out to the left. For instance, you have “427″ and you really want it to be “0000427″:
=TEXT(A1,"0000000")
The TEXT function has a few more tricks up it’s sleeve. Here’s a link to more details on it: http://www.techonthenet.com/excel/formulas/text.php
Leave a Reply
Goodreads
No data found
Or you could just use the Format Cell option ->Custom-> “0000000″. Good to know that text formula though too!
Tim, that’s true; however, it doesn’t change the underlying data, it’s simply how it’s displayed. Thus, if you were to save the file off as a csv, then you’d lose the leading 0′s.
10x, great hint!