Number.FromText

Retrieve a numerical value from the provided text string, text.text, which represents a numerical value in a standardized format like "15", "3,423.10", or "5.0E-10". The optional parameter, culture, c...

Syntax

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

About

Retrieve a numerical value from the provided text string, text.text, which represents a numerical value in a standardized format like "15", "3,423.10", or "5.0E-10". The optional parameter, culture, can be specified to determine how the text is interpreted, for instance, "en-US".

Explanation

Retrieve the numerical value of "4". Syntax: Power Query MNumber.FromText("4") Result: 4 Retrieve the numerical value of "5.0e-10". Syntax: Power Query MNumber.FromText("5.0e-10") Result: 5E-10