| || |
| || |
Join Date: Jan 2006
Re: How to define formula to Remove characters from text and leave numbers
Highlight ALL of the cells in your worksheet (click the button above the 1 and to the left of a pane where the number of rows are.
- Once you get that you just need to fomat the row now, format cells and then click the protection tab and UNCHECK the locked and hidden boxes.After this, select only the cell or cells where you want the formula to be hidden.
- If you wanted to design for more cells then you need to repeat step two, but this time CHECK THE HIDDEN Box for sure, and also the locked if you don't want the person to be able to delete your formula.Now you need to protect the sheet with the changes made to it.
- Go to TOOLS and select the protect sheet option. Once you do this, and therefor you are allow to add a password, and also there is a box where you can allow the user of your sheet to perform or not perfom options.