I have a number of calculated dimensions that have money amounts in them. When the pivot table is exported to excel using the "send to excel" option that appears when you right click the pivot table object; The money amounts are in a text format in excel.
I have used both the "Num" and the "Money" functions but nothing seams to be workings.
What do I need to do to export calculated dimensions with money values to excel that will appear in excel with the correct currency format or even as a numeric value instead of text?
