Splitting the Year from Dates

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.
 
F

Fred Smith

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.
 
P

Paul

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Splitting Year from Dates 4
How to count the numbers in a Word document? 0
Send meeting request for different dates (no repetition) to different people 0
Countif year = help needed 2
Removing {PAGE/*MERGEFORMAT} from my microsoft document 5
Sorting dates, ignoring year 3
identify which years are contained within a range of dates 2
Managing multiple jobs in a fabrication shop 0

Top