Archive

Posts Tagged ‘Function’

Left Padding Zeros in Excel

14 February 2012 19 comments

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")

=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

Categories: Excel Tags: , ,
Follow

Get every new post delivered to your Inbox.

Join 948 other followers