How to Add 0 Before a Number in Excel (No formula or VBA needed)
191.7 هزار بار بازدید -
5 سال پیش
-
In this video, I will
In this video, I will show you how to add a 0 (or multiple zeros) before a number in Excel.
When you add a 0 before a number in Excel, it would automatically be removed. For example, if you enter 010, Excel would remove the 0 and make it 10.
This may be needed if you have data such as zip codes or employee ids and you want to make all these of consistent length.
You can use Custom Number formatting to specify how long you want a number to be. For example, if you want all the numbers to ve five-digit long, you can make the custom format as 00000
This will make sure that your numbers are at least five-digit long.
This video is a part of my 'Excel is two-minute' series, where I share simple and quick tips to help you speed up your work and be more efficient
Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
When you add a 0 before a number in Excel, it would automatically be removed. For example, if you enter 010, Excel would remove the 0 and make it 10.
This may be needed if you have data such as zip codes or employee ids and you want to make all these of consistent length.
You can use Custom Number formatting to specify how long you want a number to be. For example, if you want all the numbers to ve five-digit long, you can make the custom format as 00000
This will make sure that your numbers are at least five-digit long.
This video is a part of my 'Excel is two-minute' series, where I share simple and quick tips to help you speed up your work and be more efficient
Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
5 سال پیش
در تاریخ 1398/07/14 منتشر شده
است.
191,717
بـار بازدید شده