Scientific Notation to Decimal Notation on Data Export

[steffens77Participant]

Is it possible to export a data table containing entered values in scientific notation such that the exported csv file shows values in decimal notation?

For instance, if I have an entered value of 1e6 in a number column, I want the exported data to display 1000000.

I understand there is an option to change the displayed value within DataGraph, but I cannot see that there is a way to export the displayed value instead of the entered value.

[dgteamModerator]

You are correct. The default is to export the underlying numeric data exactly as it has been entered, and there is currently no way to export a number column using the display value.

The only workaround we could come up with is to use a Text Expression column.  First, add a number column to the text expression.  Then click on the right side of the blue token.  This will give a list of formatting options, as shown below.

Hopefully, this gives you a way to do it, though it might be tedious if you have a lot of columns.

 

[Author]

Posts