show result

[atuljadhav]

Dear Sir

if any cell having formula than it show the result but in formula bar it show the formula
i want to display only result not formula in formula bar and i don't want to convert in value (copy pastspecial value)

 

[VoG]

Press F5, click Special, tick Formulas and click OK.

Press CTRL + 1, on the Protection tab tick Hidden then click OK.

Protect the worksheet.