Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power Query Not Showing second decimal if zero

I'm having an issue in excels power query.

I can not figure out how to always show two decimal places.

For example, in excel it displays like this which is perfect

  • 1.21 = 1.21
  • 1.30 = 1.30

In Power Query It displays like this

  • 1.21 = 1.21
  • 1.30 = 1.3

Power Query removes the second decimal if its a zero. I'm trying to use this as a lookup by converting it to text as its my only unique number

Need Help
  • Nolock's avatar
    Nolock
    7 years ago

    Hi Anonymous,

    use the function Number.ToText which converts a number to text with defined format.

    In your case it would be:

    Table.AddColumn(#"Changed Type", "Column1 As Formated Text", each Number.ToText([Column1], "0.00"), type text)

    And a screenshot with sample data:

1 Reply

  • Nolock's avatar
    Nolock
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi Anonymous,

    use the function Number.ToText which converts a number to text with defined format.

    In your case it would be:

    Table.AddColumn(#"Changed Type", "Column1 As Formated Text", each Number.ToText([Column1], "0.00"), type text)

    And a screenshot with sample data: