# Number.ToText problem

#### didijaba

##### Well-known Member
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
Code:
``=Number.ToText(Number.Round([NumberColumn],1),"G","")``

but it returns 5 and not 5.0
Thanks

Last edited:

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

#### AlKey

##### Active Member
Maybe with a formula

=TEXT(A1,"#0.0")

Excel 2016 (Windows) 32 bit
AB
11.23561.2
21.56251.6
322.0
455.0
Sheet6

#### MarcelBeug

##### Well-known Member
For a Power Query solution: replace argument "G" with "F1".

#### didijaba

##### Well-known Member
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

#### didijaba

##### Well-known Member
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

Last edited:

Replies
0
Views
250
Replies
1
Views
824
Replies
1
Views
311
Replies
3
Views
1K
Replies
0
Views
678

1,191,125
Messages
5,984,786
Members
439,911
Latest member
dk73

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back