Not showing year on date

Closed
Excel Iliterate - Feb 4, 2010 at 08:45 AM
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
- Feb 4, 2010 at 11:44 AM
Hello,
I have a column, which shows the month, day and year. I need to show the month and day, but not the year. It looks like just month and day in the column, but the year shows up in the box at the top.

4 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Feb 4, 2010 at 08:53 AM
What you see is the raw value
what you see in the cell is formatted value and is for display.

You are better off leaving it like that as if you remove year, the remaining thing will never consider as date by excel. In excel dates are not like 01.01.2009 but rather are like numbers like 23243 which via format you make it appear the way it appear.
0
Excel Iliterate
Feb 4, 2010 at 09:30 AM
My problem is that I am merging this into a Word document and do not want the year to show.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Feb 4, 2010 at 09:52 AM
Is it a mail merge ? In that case you can format the date on word to show up as you want
Here is how you would do it
https://ccm.net/faq/6253-date-formating-in-letters-using-mail-merge#issue


If you really want to do it then
say the date is in A1 cell
then you can use in cell B1 the formula =TEXT(A1, "mmmm dd") and then use that date
If you dont want to have formula, then once you write the formula, you can go to edit, choose copy
then go back to edit and choose paste special and choose "values"
0
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Feb 4, 2010 at 11:44 AM
Here Is Your Answer Dude.............
D7 Is That Cell Where Your Date Is..

=TEXT(DAY(D7),"dd")&" "&TEXT(MONTH(D7),"mmm")


Regards,
Naeem
0