Excel Tips : How to Add ZERO '0' Before Number etering Into Excel Sheet
This tutorials helps to how we can enter "00" Before any numerical Value in Excel Cell.
Steps :
1. Select any one cell (A1) -> Enter any one number (ex: 009254785985)
2. You can see "00" values will not visible in the cell it shows only ' 9254785985'.
3. to solve this problem, remove the number and go to Home Menu -> Open "General" option in the Numeric panel.
4. Now select "Text" option like above show.
5. Now Enter your Number (ex: 009254785985)
6. Enter -> Now you can see the number what you write exactly.
To watch this Video Click on
No comments:
Post a Comment