is it possible to create input masks to use in excel? i know there are some special formatting options available for things such as SS #, phone numers, & zip code, but there doesnt seem to be a way to add anymore - i just wondered if there was a coding way to add more? the ones i am mainly interested in seeing are a date mask dd/mm/yyyy and a time frame mask [h]:mm
i know i can format the cells to look this way, but i am wanting an actual input mask so that all the user has to do is enter the numbers and Excel adds the /s and :s where ever needed...
any ideas yall have would be wonderful...
thanks