Number.ToText problem

[didijaba]

HI,
Please help if you know how to solve this tiny problem. I have column with numbers (exampe 1.2356, 1.5625, 2, 5, ...). What I need is Power Query formula to turn those into text in format 1.2, 1.6, 2.0, 5.0 .
I used this

=Number.ToText(Number.Round([NumberColumn],1),"G","")

but it returns 5 and not 5.0
Thanks

 

[AlKey]

Maybe with a formula

=TEXT(A1,"#0.0")

Excel 2016 (Windows) 32 bit
	A	B
1	1.2356	1.2
2	1.5625	1.6
3	2	2.0
4	5	5.0
Sheet6

 

[MarcelBeug]

For a Power Query solution: replace argument "G" with "F1".

 

[didijaba]

For a Power Query solution: replace argument "G" with "F1".

Great advice, thanks very much. I haven't found anything like that anywhere on the internet. Is there any source you can point me to for such great tips? Thanks again

 

[MarcelBeug]

Coincidentally (?) I answered a similar question in post #5 of Unpivot a table of 31 columns to 12 columns

 

[didijaba]

Thanks, i have read "M is for (Data) Monkey", and went through Power Query Formula reference but I didn't see anything similar to your formula. I guess some things you just need to learn from the best . Thanks again @MarcelBeug