🎓 Learn advanced excel with our complete excel training course: eduolio.com/ex...
How to add leading zeros or add zero in front of numbers in excel:
1. Select the cell range having numbers
2. Right click and select "Format Cells" or use shortcut CTRL+1
3. Select "Number" tab and choose "Custom" as Category
4. In the "Type" field remove the text and type 00000
5. Click "Ok"
Voila, you know added leading zeros in front of the numbers in excel.
If you want to learn more excel concepts like pivot tables, dashboards, vlookup, IF formulas, conditional formatting, macros etc. Then checkout our advanced Excel course with over 10+ hours of content, 50+ exercises, doubt support and much more.
Excel Pro+ Course ► eduolio.com/ex...
🚩Follow us on:
Instagram: / eduolio
Website: eduolio.com
#excel #exceltips #exceltutorial #microsoftexcel #tutorial #microsoftoffice #googlesheets #exceltricks #tech #learn
5 сен 2024