Number.ToText

This function converts a numerical value into a text value based on the specified format. The format parameter is a text value that determines how the number will be converted. More information on the...

Syntax

Number.ToText(number as nullable number, optional format as nullable text, optional culture as nullable text) as nullable text

About

This function converts a numerical value into a text value based on the specified format. The format parameter is a text value that determines how the number will be converted. More information on the supported format values can be found at https://go.microsoft.com/fwlink/?linkid=2241210 and https://go.microsoft.com/fwlink/?linkid=2240884. Additionally, a culture parameter (such as "en-US") can be provided optionally to adjust the formatting based on cultural conventions.

Explanation

Example 1 Transform a numerical value into text without indicating a particular format. Usage: In Power Query M: Number.ToText(4) Output: "4" Example 2 Change a numerical value into exponential notation. Usage: In Power Query M: Number.ToText(4, "e") Output: "4.000000e+000" Example 3 Convert a numerical value into a percentage format with a single decimal point. Usage: In Power Query M: Number.ToText(-0.1234, "P1") Output: "-12.3 %"