change birthday display from mm/dd/yyyy to HIDE the yyyy?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The column of birthdays have the year included. I want the year portion of
the (birth)date to go away. I tried to Format in the mm/dd style then Copy,
Paste Special - Values... but it still maintains the year in the cell.
Although it is not visible on the spreadsheet, a person could simply look at
the top and see the year. Any ideas?
 

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

Converting mm/dd/yyyy to yyyy/mm/dd 6
Excel is seeing the date as dd/mm/yyyy 4
Excel function to convert month-day-year to mm/dd/yyyy 7
Splitting dd/mm/yyyy hh:mm 2
convert date mm/dd/yyyy to dd/mm/yyyy 2
how do I change the date format from yyyymmdd to mm/dd/yyyy 4
How do I convert a birthdate format from yyyy/mm/dd to mm/dd/yyyy 3
Formula to display nearest following Thursday in mm/dd/yyyy format 1

Back
Top