Hiding SS#s

[Diane Hoxeng]

Users of a form I created in Excel will be asked for their Social Security
Number in a cell. We'd like the first 5 numbers to automatically change
to x's (on screen and in print) in order to protect the person's
information. Is this possible? I am a novice Excel user.

 

[mudraker]

You could set a password character under properties for the text box. A
this sets the entered character for all text entered you would need t
set up 2 text boxes

the first with a length of 5 characters and a change event macro t
set focus on the 2nd text box once 5 characters have been entered int
the 1st text bo