stars **** in cells
 

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

--
Message posted from http://www.ExcelForum.com

stars **** in cells
 

CK,

I don't believe this is possible.


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


"cakonopka " wrote in
message ...
Hi there all.

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

cheers

from CK


---
Message posted from http://www.ExcelForum.com/

stars **** in cells
 

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.

--
Regards,
Tom Ogilvy

cakonopka wrote in message
...
Hi there all.

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

cheers

from CK


---
Message posted from http://www.ExcelForum.com/

stars **** in cells
 

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" wrote in message
...
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.

--
Regards,
Tom Ogilvy

cakonopka wrote in message
...
Hi there all.

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

cheers

from CK


---
Message posted from http://www.ExcelForum.com/