KB18754: The last digit of a 16-digit number in a report is replaced with a zero when exporting to Microsoft Excel in plaintext in MicroStrategy Web

SYMPTOM:
When a report returns a 16 digit number, if the grid is then exported to Microsoft Excel in plain text from Strategy Web, the last digit is replaced by a 0 as illustrated below:
 

 
CAUSE:
This is a known issue in Strategy Web.
 
ACTION:
Contact Strategy Technical Support for the latest status of this issue.
 
WORKAROUND:
There are two workarounds to this issue:
 

• Use Excel with formatting for Excel exports from Strategy Web containing 16 digit numbers.
• Use Excel with plaintext with the 'Export headers as text' option selected, as illustrated below: