Cell Contents, displaying *

  • Thread starter Thread starter atomic_pope
  • Start date Start date
A

atomic_pope

Hi,

Im new here but just wanted to know if anyone knows how to change th
contents of a cell to ****'s

Like in a password, if i wanted to enter 1234 but have it displayed a
****.

Anyone?!

Cheers

Andy

by the way, 1234 is not my ATM pin so dont go stealing it ;
 
one way:

Format/Cells/Number/Custom **

If your cell may contain text, use **;**;**;**

Note that the 1234 will still be visible in the Formula bar.
 
Back
Top