Can you post the pivoted file plz ? Thanks Prasad Sent from BlackBerry® on Airtel
-----Original Message----- From: Prabhu <prabhugate...@gmail.com> Sender: excel-macros@googlegroups.com Date: Wed, 31 Aug 2011 12:28:10 To: <excel-macros@googlegroups.com> Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ **Pivot Table Doubt** Hi Friends, When i double click my Pivot table value a new sheet is appearing with the details. But all the amount columns are showing in date format. Can anybody help how to rectify the same.(value should show in Number format and date should be in date format) Plz help. Regards, Prabhu -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel