ParseFloat(text)

Category: Text function

This function parses a number in scientific notation (as a text value) into a decimal number.

Return value type: Number

This is one of the few text functions that returns a non-text value.

parsefloat('1.23E-10') //Returns 0.000000000123

parsefloat('1.23E6') //Returns 1230000

• AsNumber(value)