you mean like:

=TEXT(A1,"mm/dd")


"Nancy K" wrote:

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!