Mask date format
Hi there,
I am trying to find a way to "mask" a date field so the user cannot change the format of the column, or enter any other format other than as I specify. I want the field to appear as _ _ / _ _ _ / _ _ _ _ and if the user does not enter dd/mmm/yyyy it will either not accept when they are typing or prompt "invalid date format" upon leaving the field. Thanks, JJ |
Mask date format
You'll want to use Data Validation (no code needed). Select from the drop
down to allow any date, then format the cells how you want. You'll need to protect the sheet so that other users cannot change the format. -- JNW "jjordan" wrote: Hi there, I am trying to find a way to "mask" a date field so the user cannot change the format of the column, or enter any other format other than as I specify. I want the field to appear as _ _ / _ _ _ / _ _ _ _ and if the user does not enter dd/mmm/yyyy it will either not accept when they are typing or prompt "invalid date format" upon leaving the field. Thanks, JJ |
Mask date format
Thanks JNW - works like a charm!
Why do we tend to make things more difficult than need be? :) JJ "JNW" wrote: You'll want to use Data Validation (no code needed). Select from the drop down to allow any date, then format the cells how you want. You'll need to protect the sheet so that other users cannot change the format. -- JNW "jjordan" wrote: Hi there, I am trying to find a way to "mask" a date field so the user cannot change the format of the column, or enter any other format other than as I specify. I want the field to appear as _ _ / _ _ _ / _ _ _ _ and if the user does not enter dd/mmm/yyyy it will either not accept when they are typing or prompt "invalid date format" upon leaving the field. Thanks, JJ |
Mask date format
I think that secretly, deep down inside, we like the challenge!
-- JNW "jjordan" wrote: Thanks JNW - works like a charm! Why do we tend to make things more difficult than need be? :) JJ "JNW" wrote: You'll want to use Data Validation (no code needed). Select from the drop down to allow any date, then format the cells how you want. You'll need to protect the sheet so that other users cannot change the format. -- JNW "jjordan" wrote: Hi there, I am trying to find a way to "mask" a date field so the user cannot change the format of the column, or enter any other format other than as I specify. I want the field to appear as _ _ / _ _ _ / _ _ _ _ and if the user does not enter dd/mmm/yyyy it will either not accept when they are typing or prompt "invalid date format" upon leaving the field. Thanks, JJ |
All times are GMT +1. The time now is 09:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com