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 replies

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
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.
0
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.
0
Yes that works
TEXT

Thank you very much!
Steve
0