How to Type 001 in Excel and Keep the ZEROS

Mr. Devotor

Excel keeps deleting your leading zeros? 😤 You're trying to type a number like 001 or an ID like 0456, but it disappears! In this Excel tutorial, I'll show you the 3 absolute best ways to keep leading zeros in Excel—without complex formulas.  What you'll learn:  The quickest fix (Apostrophe/Single Quote)  How to format a whole column as Text  The best method: Custom Number Format (to keep it a number for sorting!)

Transcript

00:00In this video I will guide you how to type 001 in Excel and keep the zeros with no formulas.

00:08In the first method select the cell and then right click.

00:13Go to the format cells and select the text.

00:20Click OK.

00:22And now type 001.

00:26And now you can see that you can easily type 001.

00:31In the second method put the quotation mark and type 001 and hit enter.

00:39And this is what you can easily type 001.

00:43In the third method right click and go to the format cells and go to the customs and remove the journal.

00:55And put the 30 here and click OK.

01:00And now type anything like I type 1.

01:04It is automatically type 001.

01:07And if you want to keep 4050 then what you have to do is again right click.

01:13Go to the format cells and again go to the customs and type 40 if you want to keep 40.

01:25And if you want to keep 50 another put the zero.

01:28Click OK.

01:29And this is what you can see that.

01:31If you want to type 6 you will see that there are five zeros.

01:36So I hope you have learned something new from this video.

01:39And if you think this video is helpful please support my channel.

01:43Thanks for watching.

Category

Transcript

Be the first to comment

Recommended