How to enter value starts with zero


When your input value starts with 0, Microsoft Excel will delete 0 by default, to avoid this condition use following easy steps.

1. Open an excel sheet


2. Prefix apostrophe

Prefix an apostrophe with the value as shown


3. Get the output


By using apostrophe you can get the input in your own style.

 


Susmita devnath
Accountant in a Japanes MNC
23309