In this video I’ll show you how to add trailing zeros in Excel to make numbers a specific length!
To do this, I will use the Repeat Text (REPT) and Length (LEN) functions.
For the purpose of this tutorial, I will use an example that you need to convert values of varying length into values that are 6 digits in length by adding zeros at the end.
If you find my Microsoft Excel tutorial videos informative, please give this video a thumbs up.
Please consider subscribing as it will really help my channel grow and you'll get access to subscriber-only live streams where I will answer your questions live!:
SUBSCRIBE: www.youtube.co...
☑️ About the Excellent Dude Microsoft Excel Tutorials
I create a wide variety of Microsoft Excel tutorials to help beginners all the way to advanced users.
#excelhowto #exceltutorials #learnexcel