my client says this worked in Office 97 and he formatted the cells to be
date
and then just entered numbers like 010505 and it set the formatting
correctly-any other idea?

Your client, ah, misremembers I think. Excel 97 and 2003 are the same in
this regard. Cell formatting affects how a value in a cell is displayed,
not how Excel interprets it at entry time. A macro of course can perform
all sorts of transformations so maybe that was involved.

--
Jim Rech
Excel MVP
"sj" wrote in message
...
| my client says this worked in Office 97 and he formatted the cells to be
date
| and then just entered numbers like 010505 and it set the formatting
| correctly-any other idea?
|
| "sj" wrote:
|
| enter date 010305 and the date changes to 3/18/28 very strange and can
be
| repeated. Is there a fix for this? Running excel 2003, 11.6113.5703