Forum Discussion
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 P...
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:
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: