stars **** in cells

  • Thread starter Thread starter cakonopka
  • Start date Start date
C

cakonopka

Hi there all.

I want to change a cell so that no matter what i enter it comes up wit
stars, as it is a password cell.

cheers

from C
 
You can put in a custom number format like

"*****";"*****";;"******"

but if someone selects the cell, they can see what is there in the formula
bar.
 
Unless you check the "Hide" box in the cell formatting dialog, and protect
the worksheet, but again, this is not very reliable security !

--
Regards,

Juan Pablo González

Tom Ogilvy said:
You can put in a custom number format like

"*****";"*****";;"******"

but if someone selects the cell, they can see what is there in the formula
bar.
Click to expand...
 
Back
Top