Hi Nancy

=TEXT(A1,"mmdd")

--
Regards

Roger Govier


"Nancy K" <Nancy wrote in message
...
Hi! Is it possible to remove the year from a date in Excel? I don't
mean
just format it as MMDD, but actually make the stored value just MMDD.
When I
try to Mail Merge with Word I don't want the year displayed on the
document -
the year is totally unnecessary to my purposes.

Or can a date be converted or just saved as text?

Thanks!