Forum Discussion

LarsAustin's avatar
LarsAustin
Helper I
4 years ago
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...
Need Help
  • ronrsnfld's avatar
    ronrsnfld
    4 years ago

    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

     

     

LarsAustin's avatar
LarsAustin
Helper I
4 years ago

Exactly what I need.

 

Thanks so much ronrsnfld !

 

Jojemar

ronrsnfld's avatar
ronrsnfld
Super User
4 years ago

One thing that I just noticed.

There are a number of different rounding methods (see this Wikipedia article)

Number.ToRound, by default, uses the so-called "round half to even" method (as does Excel VBA)

The rounding produced by the text function uses, I believe, the "round half away from zero" method (as does regular Excel).

 

In comparing the two, the Number.Round rounding method can be set explicitly as an optional argument.

 

So if you wanted to use a particular rounding method other than the default, you could probably round first, then format as text with two decimals.