Retain Number Format when Exporting to Excel

[cranium144]

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.

[reshmakala]

Can you please attach a sample QVW?

[Anonymous · Accepted solution]

Can't you just replace these dimensions with expressions?

[cranium144]

Exactly right. I’m not sure why I didn’t try that! Thank you.