Have you ever try to enter 0 in front of any number like 0123456 in Excel if you have then well you had a problem of Excel automatically removing 0 from the Excel work sheet this is because in Mathematics 0123 and 123 is treated as same but there are time when we need to differentiate 0123 and 123 as different numbers i had faced a smellier problem but i figure it out how we can add 0 in front of numbers in Excel here we go .
1. Open the MS Excel worksheet.
2. Type the number you want Zero in front in the cell like 12345 (you want 012345 not 12345 rite?)
3. So now Right click mouse in the cell, select Format Cells. Popup window will open .
4. Now Select the Numbers tab from the Popup window then click Custom option from the left Category: section.
5. Select 0 option from the Type section. And Type the no. of 0 one more then your number contains digit. For example, your number is 12345, now you need to make 6 Zeros i.e. 000000. Now you will notice in Sample tab it will be 012345
6. Click OK.
That's all now you will notice that your digit 12345 will be converted to 012345
1. Open the MS Excel worksheet.
2. Type the number you want Zero in front in the cell like 12345 (you want 012345 not 12345 rite?)
3. So now Right click mouse in the cell, select Format Cells. Popup window will open .
4. Now Select the Numbers tab from the Popup window then click Custom option from the left Category: section.
5. Select 0 option from the Type section. And Type the no. of 0 one more then your number contains digit. For example, your number is 12345, now you need to make 6 Zeros i.e. 000000. Now you will notice in Sample tab it will be 012345
6. Click OK.
That's all now you will notice that your digit 12345 will be converted to 012345
Do you need to increase your credit score?
ReplyDeleteDo you intend to upgrade your school grade?
Do you want to hack your cheating spouse Email, whatsapp, Facebook, instagram or any social network?
Do you need any information concerning any database.
Do you need to retrieve deleted files?
Do you need to clear your criminal records or DMV?
Do you want to remove any site or link from any blog?
you should contact this hacker, he is reliable and good at the hack jobs..
contact : cybergoldenhacker at gmail dot com