Posts Tagged ‘Function’

Left Padding Zeros in Excel

14 February 2012 26 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”:






The TEXT function has a few more tricks up it’s sleeve.  Here’s a link to more details on it:

Categories: Excel Tags: , ,