stars **** in cells

[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

 

[Chip Pearson]

CK,

I don't believe this is possible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

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

 

[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

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.