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