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

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Sorry about that! Replace Currency.Type with Currency.From.

 

--Nate

  • LarsAustin's avatar
    LarsAustin
    Helper I
    4 years ago

    Hi Nate,

     

    Thanks for that. I get a much better result than the original outcome but how can this be rounded further into 2 decimals?

     

     

    Thanks

     

    Jojemar