| Have you ever tried to insert 0 before sequel of | | | | 1. Open the MS Excel worksheet. |
| numbers in Excel? You think that what’s the | | | | 2. Write the number in the cell before you want |
| use of appending 0 before sequel of numbers | | | | to add zero. |
| because in mathematics 123 is same as 0123 but | | | | 3. Right click the mouse in the cell, select Format |
| there are some areas where these two numbers | | | | Cells… option. Format Cells window will be |
| are treated as different number. As in banks, if | | | | displayed. |
| you have an account, definitely you have an | | | | 4. Select the Numbers tab from the window then |
| account no. account no. is an entity which | | | | click Custom option from the left Category: |
| distinguishes you from all others so it must be | | | | section. |
| unique to identify you. For example account no. | | | | 5. Select 0 option from the Type section. |
| 123 is different from 0123. Both the account no. | | | | 6. Type the no. of zeroes as many as your |
| belongs to two different persons, if you write | | | | number contains digit. For example, your number |
| 0123 in the cell of excel sheet, 0 will be | | | | is 12345, so now you need to enter five zeros |
| automatically removed as we move to the next | | | | after the selected 0 in the type section i.e. |
| cell. | | | | 000000. |
| We can’t ignore zero as you know how it is | | | | 7. Click OK. The number of zeros entered by you |
| important to us. You can add zero before any | | | | will be converted to digits and the result would be |
| number by performing the following steps: | | | | 012345. |