Add Extra Digits in Excel (Leading Zeros, Ending Numbers, Text Format)

Mr. Devotor

Learn how to add extra digits to any number in Excel using simple methods. Whether you want to add leading zeros, put digits at the end, or convert numbers using formulas, this tutorial covers everything in an easy and beginner-friendly way.  In this video, you will learn: ✔ How to add digits at the beginning of a number (leading zeros) ✔ How to add digits at the end of a number ✔ How to use the TEXT function ✔ How to format numbers with custom number formatting ✔ How to convert numbers into text with extra digits  Perfect for students, office users, data entry, and Excel beginners. Watch the full tutorial and upgrade your Excel skills!  ✅ Hashtags  #ExcelTutorial #ExcelTips #ExcelForBeginners #MicrosoftExcel #ExcelFormula #ExcelTricks #LearnExcel #ExcelNumberFormat #ExcelBasics #DataEntryTips

Transcript

00:00if you want to learn that how to add extra jitters to a number in excel then you can use this

00:06formula put the equal sign and select the cell hit the space bar type ampersand space bar

00:21and double quote and add the digits which you want to add in for example i want to add in

00:29double line and double quote and hit enter and this is what you can see that the double line is added in

00:38the end of the number you can simply drag in and the results are in front of you moreover you can

00:47also use this formula put the equal sign concat bracket open select the cell comma

00:58space bar double quote hit the number you want to add in double quote and close the bracket hit enter

01:10and here you can see that you can simply use this formula also if you want to add a number before the

01:20series number for example you have added double line at the end of this number and now you want to add

01:26double line before this number so how you can do that you need to put the equal sign and double quote

01:36and put the number for example double nine and double quote hit ampersand

01:44and select the cells and hit enter and here you can see that double line is added before the this series

01:52number and simply you can drag it and the results are in front of you so if you think this video is

01:59helpful and you have learned something new please support my channel thanks for watching

Category

Transcript

Be the first to comment

Recommended