Serial Number Query

[kedalenechong]

Hi all

Please advise how to correct this Query as the Serial Number is showing

e.g key in serial number 96E156 but on the excel report 9.6E+157

SELECT T0."customer", T0."custmrName", T0."internalSN", T0."manufSN", T0."itemCode", T0."itemName", T0."status", T0."county" AS "WARRANTY START DATE", T0."instLction" FROM OINS T0 WHERE T0."customer" >=[%0] AND T0."customer" <=[%1]

[Johan_H]

Hi Kedalene,

There is nothing wrong with your query. The problem is with Excel.

When you export the report to Excel, please go about it as follows:

1. Save as text file and note to what folder you save it.
2. Close the Excel sheet that B1 opened automatically
3. Open Excel again if necessary
4. From within Excel, open the text file you saved in step 1 (you will have to change the file type from Excel to text files in the open file dialog)
5. Excel will open an import wizard.
6. In the import wizard, click next twice.
7. On the third screen of the import wizard, select the column that holds the serial numbers, and change it to type text.
8. Click finish on the import wizard

Regards,

Johan