Padding Entries in Excel

Another post inspired by the book 101 Ready-to-Use Excel Formulas by Michael Alexander and Dick Kusleika. This one is Formula #22 and covers padding entries with zeroes.

I thought I could make this formula more flexible and easier to use with a custom function.

The formula from the book is shown below.

Custom function

The flexible LAMBDA custom function to perform the same calculation is shown below.

If you are new to LAMBDA custom functions check out the post below.

Here is the custom function in use.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.