Date/Time/Social Security Number

G

Guest

I want to be able to enter four numbers into the
field and have the field automatically place
the " : " for time stamp (i.e. 11:54)

Six numbers into the field for date and place
the " / " for the dates ( 11/17/05)

Nine numbers into the SSN field
and place the hyphens for Social Security Numbers.
(000-00-0000)
Any help would be greatly appreciated.

Tom
 
J

John Vinson

I want to be able to enter four numbers into the
field and have the field automatically place
the " : " for time stamp (i.e. 11:54)
Click to expand...

Use an Input Mask of 00:00
Six numbers into the field for date and place
the " / " for the dates ( 11/17/05)
Click to expand...

Use an Input Mask of 00/00/00
Nine numbers into the SSN field
and place the hyphens for Social Security Numbers.
(000-00-0000)
Click to expand...

Use an Input Mask... well, you get the idea...

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Inputmask 1
social security numbers in Excel 3
Concantenate Social Security numbers currently parsed out 3
How to remove dashes in Social Security number 15
Help with lost focus event 1
Hide allbut last four characters of a social security number 1
Can't figure this out 1
Unformating social security numbers 4

Top