How do I change information in pivot table manually?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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).
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table - Changes 5
Pivot Table formatting in office 2003 2
Pivot Tables - sorting numbers 1
How to change the precision for Pivot Table 4
Pivot table filter list - listing irrelevant subcategorys 1
scientific notation in pivot table 1
pivot tables change number format when switching pages 1
Question on the occupied field of the pivot table in excel spreadsheet 0

Back
Top