ok i tried that, it still goes back to 2/1. this is not a fraction, it's just
a date in an expense report worksheet. however, the single apostrophe after
the date kept it in place, but i dont want to rely on that alone. there's got
to be a way to fix this for future use. thanks.

"Gary''s Student" wrote:

enter 0 2/29
the single space after the zero is necessary
--
Gary's Student


"Barb Reinhardt" wrote:

When I enter just 2/29 into a cell in excel, the resulting value is 2/1/2029.
I'm wondering if that's what you are seeing.