R
ryguy7272
Why might numbers be converted to text during an TransferSpreadsheet export
process? I know the data is in number format in the table! It goes through
a query, formatted as Currency, but then when I open the spreadsheet the
numbers are text...and this causes zeros to appear in an Excel Pivot Table.
So bizarre! I've looked all around for some kind of culprit; I'm not coming
up with anything. The answer must be staring me right in the face; just
can't see it. Any suggestions?
Thanks,
Ryan---
process? I know the data is in number format in the table! It goes through
a query, formatted as Currency, but then when I open the spreadsheet the
numbers are text...and this causes zeros to appear in an Excel Pivot Table.
So bizarre! I've looked all around for some kind of culprit; I'm not coming
up with anything. The answer must be staring me right in the face; just
can't see it. Any suggestions?
Thanks,
Ryan---