How can I change 1/30/07 to Jan-07 and drop all day info?
I've tried formating the cells, which works. But when I pivot table the info, it keeps the day so I can't combine by month. Any suggestions?
How can I change 1/30/07 to Jan-07 and drop all day info?
I've tried formating the cells, which works. But when I pivot table the info, it keeps the day so I can't combine by month. Any suggestions?
Go to custom format change to mmm-yy
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Sorry, try this so that all dates in that month go to 1st
=DATE(YEAR(A1),MONTH(A1),1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks