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
>
>
Bookmarks