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?
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?
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?
>
>
>
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
I will check into it, thanks!
"tjtjjtjt" <[email protected]> wrote in message
news:[email protected]...
> 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?
> >
> >
> >
Thanks for the idea.
"Gary Brown" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
I will research this. Thanks for the idea.
"tjtjjtjt" <[email protected]> wrote in message
news:[email protected]...
> 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?
> >
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks