How to writet zero before any digit in excel?

[Dunker]

I can't write zero prefix on excel. When I write it automatically disable. Please tell me what should I do.

[deeps]

You can add zero before any number by performing the following steps:

1. Open the MS Excel worksheet.

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

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

4. Select the Numbers tab from the window then click Custom option 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 digit. For example, your number is 12345, so now you need to enter five zeros after the selected 0 in the type section i.e. 000000.
Ads by Google

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

All the best.............!!

if u like it , plsss hit thumbs up button...!!!