Forum Discussion
Solved
Format Extracted List To Show as Currency (Or Two Decimal Number)
Hi, How can i format the list that i extracted through List.Select to a currency format? See below M code and output. My desired result is for each of the value in row under...
If you want to have your list contain values with trailing decimals, as you show, you will need to convert the Number to a text string.
One way to do that is with List.Transform...Number.ToText which will both round the number and show it with two decimals.
List.Transform(decimalList, each Number.ToText(_,"0.00"))Original
Results
If you want to have your list contain values with trailing decimals, as you show, you will need to convert the Number to a text string.
One way to do that is with List.Transform...Number.ToText which will both round the number and show it with two decimals.
List.Transform(decimalList, each Number.ToText(_,"0.00"))
Original
Results