by Jim » Thu Jan 22, 2015 9:59 am
That is a setting in the application that you use to open the downloaded file. ShopSite downloads the data as it is contained in the database which would never be scientific notation.
What application are you opening the download file in? In the spreadsheet programs I have used (Quattro Pro and Open/Libre Office Calc) when you try to open a file it prompts you to map the data columns to specific type (Text, Date, Currency, etc.) and then it uses that format when it displays. Typically you can also right click on the column header and choose a format for the data in that column.