Related:
- Date formula question
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Credit summation formula - Guide
3 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Mar 21, 2014 at 08:21 PM
Mar 21, 2014 at 08:21 PM
steve, Good evening.
Select the cell with the date.
--> Menu Format
--> Cells
--> Number
--> Custom
--> Below the word TYPE: on the field.
--> Type mmm-yy
Is it what you want?
I hope it helps.
Select the cell with the date.
--> Menu Format
--> Cells
--> Number
--> Custom
--> Below the word TYPE: on the field.
--> Type mmm-yy
Is it what you want?
I hope it helps.
Kevin@Radstock
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Mar 22, 2014 at 11:27 AM
Mar 22, 2014 at 11:27 AM
Do you mean that you require the date as a text value! May be the following and assuming your date is in A1.
=TEXT(A1,"mmm-yy")
Or in your pivot table you can group your dates. select a cell in your date column of your pivot table, right click and group, select Months & Years.
=TEXT(A1,"mmm-yy")
Or in your pivot table you can group your dates. select a cell in your date column of your pivot table, right click and group, select Months & Years.
Mar 21, 2014 at 08:23 PM
I did that and then I copied and pasted the formatted cells with copy paste special and the values to hold the formatting in place but it doesn't "stay" the computer reads the same formatting so that when you use pivot tables it doesn't sum by month year. any ideas?
Thanks!
Steve