Discussion Locked

Input mask in Excel

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there any VBA or other methods of putting a date input mask into an Excel cell?

2 replies

by al hedstrom

Yes. Format the cell or range of cells for that purpose. I don't have Excel on the box I'm currently writing, so everything here is from memory. An excellent example is SSN.
1. Select cell or range.
2. Right-click inside the selected cell(s).
3. Select Format.
4. Select special at the bottom of the list.
5. In the text box, type 000-00-0000.
The zeroes represent numbers, the dash is the separator.
6. Exit out normally.

Now in a formatted cell, type 123456789 and hit the Enter key. Viola!

Hope this helped.

Al Hedstrom

This discussion is closed to new replies.