Create Custom Entry Mask with Letters and Numbers

dreamer

New member
Joined
Oct 10, 2021
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2019
Hi everyone! I need to create custom Input Mask with Letters and Numbers with the following format:


GGPP-00-000000/00


Where,


"GGPP-" (it is a fixed data that appears in the mask),


"00" and "000000" (they are the digits that the user is going to introduce)


"/" (fixed data)


"00" (they are two digits of the year)


In addition, I would need the cursor to be positioned directly on the first "0" for the user to start typing when they focus.




What is the best way to do it? Thanks!
 
Top