Export to numeric expression to excel with more precision than displayed

[#1]

I have a numeric expression in a straight table that is formatted as money, displayed with zero decimal places.

Is there a way to export this straight table to Excel with the full numeric precision of the underlying data?  (Right now, the value of this expression column when exported to Excel is limited to the displayed precision.)

[Anonymous · Accepted solution]

Hey,

It should be possible with the use of Dual() to have one presentation value and one export value.

Please see the attached example where the last expression in the straight table uses Dual(). When I export it to Excel it shows the full decimal value. (More about Dual() in the F1-help).

[#3]

Wow, this is very cool.  Thank you!  I didn't realize you could use dual() in an expression.  The documentation seems to imply that it is valid only in the load script.

Also, the straight table is smart enough to treat the expression as numeric in the Visual Cues tab, so that highlighting by value still works.  Perfect.