Remove Year from Date
 

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!

Remove Year from Date
 

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!

Remove Year from Date
 

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!

Remove Year from Date
 

Perfect! Thanks!

"Roger Govier" wrote:

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!

Remove Year from Date
 

Perfect! Thanks!

"JMay" wrote:

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!