I've been struggling to get numbers that are more than 10 or 11 digits long to not truncate the decimals when opened as csv in excel. I need the decimals to be there so I can upload this data into a separate SQL database and if the decimals do not show in the CSV file only the whole numbers upload to SQL. If I open the file and format all the numbers as numbers (they export in general format) and resave, it will upload fine, but the purpose of this database was to import the data and have it export the files that need to be uploaded automatically without having to open each file and format etc.
For example, my query looks like this when i run it in access. There are decimals.
When I export it to CSV I get the below:
When I click in the cells of the ones that the decimals are truncated I see this:
When I sum 2 of the truncated cells they only sum the rounded numbers, which seems odd since when you click in each cell the decimals are there.
Help!