CA Loan Bajaj Finserv
CA Final Online Classes
CA Classes

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Trick to add digits in a cell in Excel

CA Rishabh Pugalia (ExcelNext) 
on 21 February 2017

LinkedIn


Now I will tell you how to add prefix "00" for a check number. For example, you have the data like below (before).



Now the point is how you will format cells in excel so that total digit should look like six digit code. It is possible to add zeroes manually. But the zeroes will go away until and unless you change the format of the cells as text. And if you do so you will not be able to apply any functions on these cells.

1. So the trick is to choose all the cells and press ctrl +1 to get the format cell dialog box.
2. Now go to custom in general type six (6) zeroes.

Notice as soon as you type six zeroes, in the preview, you can see it has added two zeroes before the numbers. And then press ok. Now you are done. This is the format you are looking for. Remember one thing it is just the format and the length of the character does not change. It is just for representation purpose.

Recommended course to learn MS Office tools like Advanced Excel, Charts, PowerPoint Ninja, VBA Macros and Word for Finance Professionals.

Click below to enrol in a course to learn MS Office tools like Advanced Excel, Charts, PowerPoint Ninja, VBA Macros and Word for Finance Professionals.

/coaching/584-ms-office-bundle.asp


Tags :



Category Students
Other Articles by -
CA Rishabh Pugalia (ExcelNext) 

Report Abuse

LinkedIn



Comments


update