password in a cell

[Shaves]

Is there a way to display a cell as "*****" when the user enters data into a
particular cell. I realize it may be displayed in the status bar, but I
would prefer the contents not be visibile to anyone casually walking by this
computer.

Thanks for the help.

 

[Dave Peterson]

It'll appear normally in the Formula bar--so don't select the cell when someone
walks by!

Format|Cells|Number tab|Custom category
"*****";"*****";"*****";"*****"
(positive;negative;zero;text)

 

[Rayashe]

You could just try and change the format of the cell:
Format Cells>Number>Custom and then enter as Type: ;;;*x
This will fill the cell with x's - don't think you can use the * by itself
though as it is a function.
Don't know about a way to prevent it showing in the status bar apart from
hiding the status bar

 

[T851]

I'm only a basic novice but you could try protecting the sheet, adding
further, before you protect the sheet select the check box for "Hidden" on
the format menu, this will then not show any data on the formula bar, you
could then use the windings font for the password in the cell, hope this helps