Best Offer for Books in Amazon

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.


No comments:

Post a Comment

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.