Date formula question

Closed
Steve - Mar 21, 2014 at 05:38 PM
 steve - Mar 25, 2014 at 06:49 PM
Hello,
How do make the month date year such as 1/1/2014 to hard code month-year Jan-14 for use in pivot table?
Thanks


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
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.
Hello
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
0
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
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.
Yes that works
TEXT

Thank you very much!
Steve