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

Thanks

If you're not including the year as part of your date entry Excel defaults to
the current year, and this year is not a leap year.
--
Kevin Backmann


"P M Robbins" wrote:

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

Thanks

Are you specifying 2004 as the eyear when you enter it? Excell defaults
to current year, so if you just enter 2/29, it will interpret it as
2/29/06, which is an invalid date. Enter 2/29/2004 & see if it works.

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=528255

Are you entering 2/29 by itself? Well, Excel will add the current year
automatically, and *try* to enter Feb 29, 2006, but there was no Feb 29 this
year.

If you are actually entering 2/29/04, then what do you mean Excel won't
accept it?



"P M Robbins" wrote:

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

Thanks

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

What are you trying to enter it as?

The text string: "2/29"?
precede your entry with an apostrophe (') like this
'2/29
or format the cell as text BEFORE you insert 2/29.

The date: Febuary 29?
include a year that is a leap year. If you want only 2/29 to show you can
use a custom format like
m/d

The fraction 2/29 (0.068966 as a number)?
format the cell as a number before you enter 2/29. If you want the cell to
show as a fraction you can use a custom format of
###/###

"P M Robbins" wrote:

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

Thanks