didijaba
Well-known Member
- Joined
- Nov 26, 2006
- Messages
- 511
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
but it returns 5 and not 5.0
Thanks
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
Code:
=Number.ToText(Number.Round([NumberColumn],1),"G","")
but it returns 5 and not 5.0
Thanks
Last edited: