Zero padding to the week numbers in Excel

In this article, we will learn about how to pad zero with week numbers in Excel.

WEEKNUM function returns the week number of a year. There are 53 weeks in a year. So the function returns a value between 1 to 53.

As we already know, WEEKNUM function takes the date of the year as an argument and returns its week number of the year.


= WEEKNUM ( Serial number )

Here we have some dates to test the function.

Use the formula:


31st of the first month of the year returns 5.

Now copy the formula in the remaining cells using Shortcut key Ctrl + D.

The function returned the week number of the year as required.

Now we need to pad zero in the above results as changing the formatting of the call value.

Here TEXT function is used to change the cell value formatting.

= TEXT ( text , text_format )

Now let's use the TEXT function on the results of the WEEKNUM function.

Use the formula:

= TEXT ( B2 , "00" )

"00" : 2 digit number. As WEEKNUM function returns value between 1 - 53.

As you can see from the above snapshot that how to pad zero in front of the number

Hope you understood how to pad zero with week numbers in Excel. Explore more articles on Excel Date & Time function here. Please feel free to state your query or feedback for the above article.

Related Articles

How to use the WEEKNUM function in Excel

How to use the TEXT function in Excel

Convert Text to Numbers

Popular Articles

The VLOOKUP Function in Excel

Conditional Formatting with formula 2016

create Overlay Chart in Excel 2016

Leave a Reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube