How do I change information in pivot table manually?

B

Bodeene

I am creating a pivot table that includes cut lengths listed in decimal
format (4 digits after decimal). But in the pivot table I need the numbers
to show in fraction format. This information will be dumped into Microsoft
Access and it will only see the numbers as decimals. What can I do? (I am
using Excel 2002).
 
B

Bernie Deitrick

Bodeene,

You should be able to select the cells in the pivot table and format them
for fractions, just as you would any cell.

HTH,
Bernie
MS Excel MVP
 
Top