Power Query Not Showing second decimal if zero

[Anonymous]

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

[Nolock · Accepted solution]

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: