PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Crashes Pivot Table

Reply

Pivot Table

 
Thread Tools Rate Thread
Old 25-04-2005, 10:20 PM   #1
Gerry Bennett
Guest
 
Posts: n/a
Default Pivot Table


I'm creating a pivot table, but the data in the piviot
table cells are rounded up. I have created a worksheet
with the time format (custom) as m:ss.00 This shows
correct in the cell as say 1:34.96 However in the
function bar it is rounded up to say 1:35 also in the
pivot table it shows the same (rounded up) how can I get
the cell in the pivot table to reflect the same as the
worksheet cell.
  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off