Format Cell as ****

[Richard_123]

Hello,

I want to format a cell so that it always displays *****s (as a password
field would), regardless of the content of the cell.

Is there a custom formatting which will do this?

Thanks.

 

[Bernard Liengme]

No, but you could format that cell to give the font the same colour as the
cell background.
Of course, one can still read the value when that cell is the active cell as
the text will show in the Formula Bar. But that is also true if there had
been a format to solve your problem. In older Excel, the text might be
readable when the cell is active as active cells get shaded - no so in
XL2007 or 2010beta,
best wishes

 

[Dave Peterson]

You could use:
"****";"****";"****";"****"

But that only hides the value in the sheet--you can still see the value in the
formula bar when the cell is active.