Power Query
Search…
Number.FromText

Number.FromText

Creates numbers from common text formats ("15", "3,423.10", "5.0E-10").
function (optional text as nullable any, optional culture as nullable any) as nullable any

Description

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

Category

Number.Conversion and formatting

Examples

Get the number value of "4".
1
Number.FromText("4")
Copied!
4
Get the number value of "5.0e-10".
1
Number.FromText("5.0e-10")
Copied!
5E-10
Last modified 3yr ago