How to add leading zeros in Excel

Hello, My Dear Friends, !! In this video, I will show you How to add leading zeros in Excel. Watch the video till the end Thanks.

Here,s How to add leading zeros in Excel :

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Step 1: Select the cell in which you want to add zeros as a prefix.

Step 2: Right-click ➜ Format Option or you can also use the shortcut key Ctrl + 1 open “Format Cell Dialog Box”.

Step 3: In Category ➜ Select Custom.

Step 4: In the custom input dialog box, enter “0000000”.

Step 5: Click OK.

Chapters:

0:00 Introduction

0:13 Add leading zeros in Excel

2:50 Happy Ending

Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel.

#initial #solution #add #leading #zeros #in #Excel

Initial Solution