Format Cell as ****

  • Thread starter Thread starter Richard_123
  • Start date Start date
R

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