Trick to add digits in a cell in Excel

Last updated: 21 February 2017

Save Share

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

Daily Limit Reached