Deep Patel: June 2013

Wednesday, June 5, 2013

Masking the characters in a cell with Asterisk/Password Characters for text in an excel Cell.

Sometimes we enter password in Excel Sheet(eg. Excel vba Utilities)
It is desired that the password be masked using Password Characters(like *)

This can be done by following steps.

1.    Select the step you want to mask with Password Characters




2.    Go to Format Cells>Number >Custom


3.    Enter the Type as mentioned in the below screenshot and press OK


4.    The data in the cell now appears masked as shown below