Discussion Locked
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
by kweinhold
Thanks for you help!!
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending
1 helpful
16 replies
0 helpful
12 replies
0 helpful
3 replies
0 helpful
2 replies
Question
Is WSL still relevant in 2026?
0 helpful
1 reply