Splitting the Year from Dates

  • Thread starter Thread starter Mollas
  • Start date Start date
M

Mollas

Hello,

How do I split the year for dates. The purpose is to prevent viewers from
reformatting the date to find out the year.
 
Sorry, all dates in Excel contain a year. You could look at using text,
rather than dates, or protecting the cell. Or tell us more about what you
need to do. There'll be a solution.

Regards,
Fred.
 
There are quite a few ways to achieve this. One way

=TEXT(A1,"mmm-dd"), then copy, paste special>values on same cell and
remove entry in A1.

Paul
 
Back
Top