Number.FromText

Creates numbers from common text formats ("15", "3,423.10", "5.0E-10").

Syntax

Number.FromText(
    text as text,
    optional culture as text
) as number

Returns a number value from the given text value, text.

text: The textual representation of a number value. The representation must be in a common number format, such as "15", "3,423.10", or "5.0E-10".
culture: An optional culture that controls how text is interpreted (for example, "en-US").

Get the number value of <code>"4"</code>.

Number.FromText("4")

Result:

Get the number value of <code>"5.0e-10"</code>.

Number.FromText("5.0e-10")

Result:

5E-10