importing data from acces to excel with 2 decimals

[Wimsterfriend]

When exporting data from access to excel with a pivot table, the decimals are not displayed in the pivot table even if in the access table the parameter is set to standard, decimal and double. How can this be solved?

 

[Gerald Higgins]

Sounds like it COULD be simply a formating problem in Excel. Select the data in your pivot table, and use normal Excel formating tools to change the number of decimal places displayed.