The ASAP Utilities menu in Excel (English)
Fill up with leading zeros...
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語Numbers & Dates › 12. 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
Starting this tool
- Click ASAP Utilities › Numbers & Dates › 12. Fill up with leading zeros...
- Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...
Additional keywords for this tool:
add leading zeros, padding
add leading zeros, padding
©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
Empowering Excel Users Worldwide for 25 Years
Empowering Excel Users Worldwide for 25 Years