View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Format Cell as ****

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.

Richard_123 wrote:

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.


--

Dave Peterson