Thread: Password mask
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Password mask

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

In article ,
Perico wrote:

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.