Password mask

[Guest]

Is there a way to mask sensitive data in a cell? For example, if a customer
enters their tax id, can it be formatted or masked as ********, similar to
what can be done in MS Access? Thanks.

 

[JE McGimpsey]

You could choose Format/Cells/Number/Custom and enter

**

as the format, but the id will still be plainly visible in the Formula
bar or if the cell is used as a reference by another cell, e.g.,

Value Cell Display
A1: 12345 ********
B1: =A1 12345