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
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
4 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 4, 2010 at 08:53 AM
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.
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.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 4, 2010 at 09:52 AM
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"
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"
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
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
D7 Is That Cell Where Your Date Is..
=TEXT(DAY(D7),"dd")&" "&TEXT(MONTH(D7),"mmm")
Regards,
Naeem