View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Judy Judy is offline
external usenet poster
 
Posts: 53
Default ### showing up in pivot table.

My data has a col called Dur which is a calculation subtracting one time from
another time. Depending on my filtering in the pivot table depends on how
many cells contain ###. I have the data formatted as General and Dur in the
PT is formatted as custom [h]:mm:ss
Any assistance with getting my data to show up as hh:mm:ss to replace the
### would be appreciated.
--
Thanks,
Judy