That would hide the result but the formula would still be visible in the
formula bar.

Regards
Rowan

Desert Piranha wrote:
Lawrence Wrote:

hi,

could anyone tell me how to cover the formula in the column, so that
people
unable see what the formula i have put in.

thanks in advance...

LawrenceHi Lawrence,

Another way is custom format the cells with ;;; that is three
semicolons.
FormatCellsCustom key in ;;; click Ok
Then protect the sheet.