
1. Re: Scientific Notation for large and small numbers
jveilleux Jun 6, 2017 3:24 PM (in response to jveilleux)1 of 1 people found this helpfulI just found the solution. In the SCIN function, drop the space before the "E" and it solves the problem. It shows up in scientific notation and exports properly. Here it is:
/*
ScientificNotation function
Author
*COMMENT Visual Realisation
Format
ScientificNotation ( number ; precision )
Parameters
number  any numeric expression or field containing a numeric expression
precision  any numeric expression or field containing a numeric expression
Data type returned
Number (had been text)
Description
Returns number, rounded off to the specified precision (number of decimal places), formatted in scientific notation.
April 24, 2005
*/
Case (
number = 0 ; 0 ;
Let ( [
exponent = Floor ( Log ( Abs ( number ) ) ) ;
significand = Round ( SetPrecision ( number / 10^exponent ; 400 ) ; precision )
] ;
significand & "E" & Case ( exponent > 0 ; "+" ) & exponent //remove the space before the E
) // end Let
) // end Case