Thread: Data in my pivot table changes to zeros
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MyrtlePeacock
 
Posts: n/a
Default Data in my pivot table changes to zeros

Thanks for the advice. I used the "Paste Special" method to convert the
text numbers into real numbers on my data list and then updated my PTs.
All the zeros were gone and I now have the correct data where it should
be.

Thanks again.


--
MyrtlePeacock
------------------------------------------------------------------------
MyrtlePeacock's Profile: http://www.excelforum.com/member.php...o&userid=29812
View this thread: http://www.excelforum.com/showthread...hreadid=495192

Reply With QuoteReply With Quote