Hello, Rohit. Copy the cells with formulas, then on a new worksheet (or even
in same location), hit Edit--Paste special--Values.
*******************
~Anne Troy

www.OfficeArticles.com


"ROHIT" wrote in message
...
I want to hide Formula in Formulabar...

example:I apled formula in B2 to B6 Cell is "=IF(B335,"Pass","Fail")"
A B
1 Number Condition
2 20 Fail
3 36 Pass
4 30 Fail
5 40 Pass
6 30 Fail
7 60 Pass

Now anybody put a cell pointer in B2 to B7, "If" formula is shown in
Formulabar, I want to hide my Formula for no body can see which formula is
appliyed.

Thanking You.