Pivot table seems to round my figures up!

[raehippychick]

I have a pivot table that works very nicely except for one thing - th
data has come through all rounded up

e.g. in the data source sheet one column has the following figures:

0.69
0.94
1

but when I create the pivot table it shows all the data as 1

I have formatted all the source cells as number wit 2 decimals and als
the numbers cells in the pivot table -

now they look like 1.00

I really need to be able to show the 0.69 and 0.94 as well as the 1.00

Is this possible please?

Many thanks in advanc

 

[Bernie Deitrick]

RaeHippyChick,

Make sure that you are using SUM or AVERAGE (or whatever you want to
actually return) and not COUNT (which is the default).

HTH,
Bernie
MS Excel MVP

 

[raehippychick]

Bernie

Thank you so much (... again) - you are great

I have tried this and now have lovely little numbers coming up where
wanted them

Very many thanks

Rae the happy hippychick!