**Read my second reply before trying this**
So no matter what you open the file in it is in scientific notation? Or are you only trying Excel? Because this is an issue with Excel usually. Depending how long the numbers are Excel really does not like playing with things over 15 digits. In my testing this happens with all numbers that have 12 or more digits.
I use the web version of Excel, this may be slightly different with the actual program. I made sure this was a good test because this data is pulled from Quick Base where I had numbers stored that Excel turned into scientific notation when loaded in. So it should work for you just the same.
What you can do to convert your numbers back to the full number, and this needs to be done on each and every column with a number, is use the Number Format option. Simply right click the column and select "Number Format..." then select the options as my screenshot shows. This will convert the numbers for you. It fixed numbers for me that Excel had changed to scientific format as well as adding decimals that didn't belong.
Original Message:
Sent: 05-09-2020 08:45
From: Paul Peterson
Subject: CSV Export problem
I tried that approach and am still getting the numbers in scientific notation
------------------------------
Paul Peterson
Original Message:
Sent: 05-08-2020 17:52
From: Paul Peterson
Subject: CSV Export problem
Thank you
------------------------------
Paul Peterson
Original Message:
Sent: 05-08-2020 17:49
From: Ravi Bala
Subject: CSV Export problem
Do not open the CSV file. Use Get Data or From Text/CSV in a new excel sheet and select the csv file. It will load csv file data correctly without scientific notation.
------------------------------
Ravi Bala
Original Message:
Sent: 05-08-2020 08:07
From: Paul Peterson
Subject: CSV Export problem
I have several subscriptions and notifications sent out on a regular basis. Some of the users are requesting the data sent in a CSV file rather than being embedded in the email. The problem I am encountering is when the csv file is created, it is truncating some of the numbers into scientific notation even though they are in a text field in Quick Base. Is there any way to prevent the csv file from changing the number format?
------------------------------
Paul Peterson
------------------------------