You don't say if you're receiving an error of if Excel is converting your
input value to a different value.

Here's a guess:
Enter the complete date: 2/29/2004

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"P M Robbins" wrote:

> I'm trying to insert 2/29 in a 2004 worksheet and excel will not accept it.
> Any thoughts?
>
> Thanks
>
>