View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nancy K Nancy K is offline
external usenet poster
 
Posts: 1
Default 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!