stars **** in cells

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
 
T

Tom Ogilvy

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.
 
J

Juan Pablo González

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...
 
Top