Hello,
how do i remove everything but the year from a list of dates. I don't want to hide it i want to physically get rid of it. As the hiding or custom formating still means i get hundreds of values for the same year in my pivot table.
Regards,
Joshua
You can group dates by years in Pivot Tables without changing the original dates
Hi use formuladrag it down and then copy this and paste special (values)Formula:
Please Login or Register to view this content.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Originally Posted by Pepe Le Mokko
Can you explain how for future reference?
When i do that for 02/01/2007 i get 1905?Hi use formuladrag it down and then copy this and paste special (values)Formula:Please Login or Register to view this content.
So it means that You do not have date format in your cells so even idea of Pepe Le Mokko will not help.
Send small sample If You can
Datelist.xlshere is the data list atm - i just want the dates
Look into attachment and tell is it ok because I could misunderstood You.
Thats great how did you do that?
When your PT has been created and the dates are row fields, say, right click them - click "group" and select "years".
You can also choose to hide details
1. use formula =Year(a2) in B2Thats great how did you do that?
2. copy down formula
3. select column B
4. copy
5. paste special (choose values)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks