I'm looking for a way to retain the number formatting when exporting to Excel. Currently, I have a PivotTable and a Straight Table that are exporting the data formatted visually correct, but the numbers have the apostrophe in front making Excel see them as characters. I have tried changing the document number settings but that did not work.
It does seem that this only happens on Dimensions. The Expressions seem to be formatted correctly and seen as numbers in Excel.
