Leap year date

P

P M Robbins

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

Thanks
 
K

Kevin B

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.
 
G

gjcase

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
 
D

Duke Carey

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?
 
R

Ron Coderre

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
 
S

Sloth

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
###/###
 
Top