logo ASAP Utilities

You can do this too

Download "The one essential add-in for all Excel users."
Sit down and relax, while ASAP Utilities does the rest!

“Working in Excel will be fun again with all these extra supersmart tools”

ASAP Utilities, description of our Excel tools

English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語

Numbers & Dates » Fill up with leading zeros...

This utility fills the numbers in the selected cells up with leading zeros to a given length.
The utility will actually add the zeros and therefore change the data. If you only need the number to be displayed as if they have leading zeros then it is better to use cell formatting with a number format such as for example '000000'.
Numbers with decimals will be rounded to the nearest integer.

For example if you specify a length of 3 then a cell with the value 1 becomes 001, 34 becomes 034 and numbers greater than 100 will not be changed because they already have a length of 3 characters or more
If a formula in your selection has a number as a result then the calculated value will be filled it up with the zeros and the original formula is replaced.

Screenshots

Numbers & Dates » Fill up with leading zeros...

Starting this utility

In the Excel menu choose: ASAP Utilities » Numbers & Dates » Fill up with leading zeros...

« Return to the list of “Numbers & Dates” tools.
« Previous
Round numbers (not formatting, but changing)...
 
 Next »
Quick numbering of selected cells...
Excel 2010 with ASAP Utilities in the menu
Download ASAP Utilities
Additional keywords for this tool:
add leading zeros, padding

Follow ASAP Utilities on Facebook



Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2017 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook