Posted by Efendi on February 07, 2002 6:30 AM
1. I would like to make all formulas hidden and I tried to do it but it does not work. What I did: I clicked on "Hidden formulas" in Format - Cells - Protection. Then I put the password in Tools - Protection - Lock sheets. It does not work - why?
2. In one column I have some datas in various forms, for example "num. of check 00124", or "00124 num. of check", or "number 00124 - check" and like this. I need to extract just number from it - how to do it by some quick way?
Thank in advance:-)