Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 57
Default Password mask

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   Report Post  
Posted to microsoft.public.excel.programming
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
date mask sgibbs Excel Discussion (Misc queries) 1 August 17th 05 10:50 PM
mask Tom Excel Programming 1 February 18th 05 06:39 PM
Input Mask Jimmy Clay New Users to Excel 3 December 1st 04 01:16 AM
Password mask jose aponte Excel Programming 1 September 10th 03 10:49 PM
Password mask jose Excel Programming 2 September 10th 03 09:03 PM


All times are GMT +1. The time now is 06:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"