How to Insert 0 Before Any Number in Excel

Have you ever tried apt insert 0 before sequel of mathematics in Excel? You calculate namely what’s the use of appending 0 ahead outcome of mathematics for in numbers 123 namely same as 0123 yet there are some areas where these two mathematics are remedied as another digit. As in banks, whether you have one list, definitely you have one account not. account no. is an entity which distinguishes you from all others so it must be distinctive to identify you. For sample account no. 123 namely differ from 0123. Both the account no. belongs to two differ persons, if you jot 0123 in the cell of excel sheet, 0 will be automatically removed as we push to the afterward cell.

We can’t ignore naught as you know how it is momentous to us. You tin multiplication naught before anyone number along acting the emulating steps:

1. Open the MS Excel worksheet.

2. Write the number in the cell before you ambition to add zero.

3. Right press the mouse in the cell, select Format Cells… option. Format Cells window will be exhibited.

4. Select the Numbers tab from the window then click Custom alternative from the left Category: section.

5. Select 0 option from the Type section.

6. Type the no. of zeroes as many as your number contains number. For example, your number is 12345, so now you absence to enter 5 zeros after the selected 0 in the type section i.e. 000000.

7. Click OK. The number of zeros entered by you will be converted to digits and the outcome would be 012345.

MS excel file which involve transaction records, value payable, value receivable, inventory control records gets corrupt due to virus bombards, hardware malfunction, improper system shutdown, mistake in the disk, power failure and many more. To fix excel file and retrieve formulas, images, charts, clip art, flow charts, txt, worksheets and workbooks stored in excel file, excel recovery software must be employed. To fix corrupt excel files, several excel repair software are obtainable in mall, which help you to regain important data from corrupt excel files. RecoveryFix as Excel is an such tool to repair corrupt excel file. For more information visit http://www.repairexcelfile.net