Type hidden text and/or numbers; return asterisks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to type a name or series of numbers or a combination in a cell without anyone that may be standing around seeing what I am typing in and have it return asterisks (or another character). This would be like entering a password for an application and instead of the characters you are typing, you would see asterisks for example. The data being typed into the cell might be used in a formula elsewhere in the worksheet. I've hidden the formula bar so that you can't see what's being typed in there. And, I tried adding a custom format to the cell that returned single quotes across the cell, but you can still see what is being typed in the cell and this only works for text. Any ideas? Thanks. kj
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top