Best Offer for Books in Amazon

Showing posts with label Zero values before number value in excel.. Show all posts
Showing posts with label Zero values before number value in excel.. Show all posts

Friday, 22 November 2019

HOW TO SHOW 0 VALUES BEFORE THE NUMBER IN EXCEL


Worrying about Add '0' values before Number in Excel .

Don't Worry I will show you How to visible 0 values before any number value

Let's look here


steps:
1.  Type any one value (ex: 0012345) in excel cell as per show above and select it.
2. go home menu->  Number Section -> Change 'General' to 'Text'.
3. Now it gives an Error message at right corner of the cell -> Set Ignore Error.


How to Protect sheet in Ms-Excel

STEPS:  1. OPEN Ms-Excel 2. Go to Review-> Protect Sheet -> Protect sheet  3. enter Password -> Re-enter Password-> save.