Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
date mask | Excel Discussion (Misc queries) | |||
mask | Excel Programming | |||
Input Mask | New Users to Excel | |||
Password mask | Excel Programming | |||
Password mask | Excel Programming |