Repair Inserts

<

Have you ever tried to insert 0 before sequel of numbers in Excel? Do you think what is the use of appending 0 before sequel of numbers because in mathematics 123 is like 0123 but there are some areas where these two numbers are treated as different number. Like the banks, if you have an account, you definitely not have an account. account no. is an entity that distinguishes it from all others for what they must be unique to identify you. For example, account no. 123 is different from 0123. Both the account no. belong to two different people, typing 0123 Excel cell sheet, 0 will be automatically removed as we move to the next cell.

We can not ignore zero as you know how it is important to us. You can add any number zero before performing the following steps:

1. Open the worksheet MS Excel spreadsheet.

2. Type the number in cell before you want to add to zero.

3. Right click the mouse in the cell, select Format Cells ... option. Format Cells window will be displayed.

4. Select the Numbers tab of the window then click Customize option left section Category:.

5. Select the 0 of the type section.

6. Type no. many zeros as the number containing digits. For example, their number is 12345, so now you need to enter five zeros after the selected type 0 in the section ie 000000.

7. Click OK. The number of zeros introduced by you will become digits and the result would be 012345.

MS Excel file containing records of the transaction, the amount payable, receivable, inventory control records is corrupted due to virus attacks, hardware malfunction, improper system shutdown, disk failure, power failure and many more. For the Excel file repair and recover formulas, images, graphics, clipart, graphics, text, spreadsheets and books stored in the Excel file, Excel recovery software to be used. For the repair corrupt excel files, multiple Excel repair software are available on the market that help you recover important data from corrupt Excel files. RecoveryFix for Excel is one such tool to repair corrupt excel files. For more http://www.repairexcelfile.net information, visit

About the Author:

This article is provided by Chily Softech - imminent provider of professional Excel recovery software.

Article Source: ArticlesBase.com - How to Insert 0 Before Any Number in Excel