Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input Mask for Dates
I have a number of users (Excel 2000 and 2002) who want the ability to put
dates into cells without typing the slashes. This would best be described as the "input mask" available in Access. Is there anything available in Excel to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input Mask for Dates
How about this?
http://www.rondebruin.nl/qde.htm -- tj "Brenda Rueter" wrote: I have a number of users (Excel 2000 and 2002) who want the ability to put dates into cells without typing the slashes. This would best be described as the "input mask" available in Access. Is there anything available in Excel to do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input Mask for Dates
You can't do exactly what you can do within Access, unless you want to run some sort of macro, however, you can use data validation to enter dates without slashes into one cell and get excel to convert the text entry in the adjacent cell into a correct date. The data validation could be a custom data validation, assuming the data entry cell is A1 with a text formating and the resulting date appears in B1, then =AND(IF(VALUE(LEFT($A$1,2))<DAY($B$1),FALSE,TRUE) ,IF(VALUE(MID($A$1,3,2))<MONTH($B$1),FALSE,TRUE), IF(VALUE(20&RIGHT($A$1,2))<YEAR($B$1),FALSE,TRUE) ,LEN(A1)=6) The date would need to be entered as DDMMYY, with a day entered as 06 not just 6 G -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=535485 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input Mask for Dates
I will check into it, thanks!
"tjtjjtjt" wrote in message ... How about this? http://www.rondebruin.nl/qde.htm -- tj "Brenda Rueter" wrote: I have a number of users (Excel 2000 and 2002) who want the ability to put dates into cells without typing the slashes. This would best be described as the "input mask" available in Access. Is there anything available in Excel to do this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input Mask for Dates
Thanks for the idea.
"Gary Brown" wrote in message ... You can't do exactly what you can do within Access, unless you want to run some sort of macro, however, you can use data validation to enter dates without slashes into one cell and get excel to convert the text entry in the adjacent cell into a correct date. The data validation could be a custom data validation, assuming the data entry cell is A1 with a text formating and the resulting date appears in B1, then =AND(IF(VALUE(LEFT($A$1,2))<DAY($B$1),FALSE,TRUE) ,IF(VALUE(MID($A$1,3,2))< MONTH($B$1),FALSE,TRUE),IF(VALUE(20&RIGHT($A$1,2)) <YEAR($B$1),FALSE,TRUE),L EN(A1)=6) The date would need to be entered as DDMMYY, with a day entered as 06 not just 6 G -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=535485 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input Mask for Dates
I will research this. Thanks for the idea.
"tjtjjtjt" wrote in message ... How about this? http://www.rondebruin.nl/qde.htm -- tj "Brenda Rueter" wrote: I have a number of users (Excel 2000 and 2002) who want the ability to put dates into cells without typing the slashes. This would best be described as the "input mask" available in Access. Is there anything available in Excel to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Input mask for active cell | Excel Discussion (Misc queries) | |||
Input Mask | Excel Worksheet Functions | |||
Time input mask format | Excel Discussion (Misc queries) | |||
input mask in excel | Excel Worksheet Functions | |||
Input Mask | New Users to Excel |