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
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.
You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/
#Excel #ExcelTips #Excelin2Minutes