Save as spreadsheet issue
Good day,
I have a report and one of the columns collects serial numbers, the serial numbers are 24 characters long. There are over 6000 entries. Every time anyone tries to use the Save to Spreadsheet option, the column opens in excel but one column is truncated. No matter how I save it, it does not pull the information down properly.
For example it will change a number like this: 183412203011023907608178 to something like this:1.83352E+23
The only way to export the data properly is to go into Import/Export and export as a Tab-Delimited value, save it. Then copy and paste it into a new excel file.
I want my client to be able to as they normally do, click on the Save as Spreadsheet on the report and be able to download the report with out any changes. The field in question is a text field.
------------------------------
Mr Delemar
------------------------------
I have a report and one of the columns collects serial numbers, the serial numbers are 24 characters long. There are over 6000 entries. Every time anyone tries to use the Save to Spreadsheet option, the column opens in excel but one column is truncated. No matter how I save it, it does not pull the information down properly.
For example it will change a number like this: 183412203011023907608178 to something like this:1.83352E+23
The only way to export the data properly is to go into Import/Export and export as a Tab-Delimited value, save it. Then copy and paste it into a new excel file.
I want my client to be able to as they normally do, click on the Save as Spreadsheet on the report and be able to download the report with out any changes. The field in question is a text field.
------------------------------
Mr Delemar
------------------------------
