Date Entry in Excel 2000

[Erin]

Hi All,

We recently upgraded to 2003 and one of our users says she
was able to enter a date such as 10/24/04 in Excel 2000 as
102404 when she had the cell formatted as a date. I
haven't been able to reproduce it on a 2000 machine nor
does it make sense to me that it would work given that a
date in Excel has a numeric value which is unrelated to
the digits in the date.

Is she mistaken or is there a setting I don't know about
which allows this?

Thanks

Erin

 

[JE McGimpsey]

She's most probably mistaken. That behavior isn't native to XL. It's
possible to do this with event macros:

http://cpearson.com/excel/datetimeentry.htm

but that's usually implemented in a workbook rather than, say, in an
add-in that would provide this behavior generally.

 

[Ron Rosenfeld]

Hi All,

We recently upgraded to 2003 and one of our users says she
was able to enter a date such as 10/24/04 in Excel 2000 as
102404 when she had the cell formatted as a date. I
haven't been able to reproduce it on a 2000 machine nor
does it make sense to me that it would work given that a
date in Excel has a numeric value which is unrelated to
the digits in the date.

Is she mistaken or is there a setting I don't know about
which allows this?

Thanks

Erin

There would have had to have been a VBA event-driven macro to allow that to
occur. It was probably restricted to a certain area, or else Excel would not
be able to tell the difference between a date entry and a number entry.


--ron