Importing a generated RMA Report into Excel (without scientific notation)

  • Updated

Where Excel automatically opens the CSV file for a generated RMA Report, scientific notation may be defaulted to within select columns, including for tracking numbers populated under "Tracking Number":

Scientific_Notation.png

Towards preventing scientific notation from being defaulted to for any data, take the following steps to instead manually import the report's downloaded CSV file:

  • Open Excel with a new "Blank Workbook".

Blank_Workbook.png

  • Click into the "Data" tab, and select the "From Text" option.

Data_Tab.png

  • Select the downloaded CSV file. If using any software version other than Excel 2016, this will open the "Import Wizard" to be utilized during the following steps.
  • Select (or keep selected) the "Delimited" data type, and click "Next".

Text_Import_Wizard_1.png

  • Check the "Tab" and "Comma" options for "Delimiters," and click "Next".

Text_Import_Wizard_2.png

  • Highlight/select the depicted "Tracking Number" column and change the "Column data format" to "Text," and click "Finish".

Text_Import_Wizard_3.png

  • Within the report's "Tracking Number" column, for one, tracking numbers should then be reflected as unique and in full:

Updated_RMA_Report.png

.