Forum Discussion
Quetion related to convert text into number
Hello Everyone,
In below images the Sales column is in Text format. So how to convert Text format into Number format with the help of formula?
select a cell in your "data table" and go to:
Data->Get & Transform->Table/Range
This is from the microsoft page linked below. Bold text = my guessing of relevant settings
- Right-click a query column.
- Click Change Type > Using Locale.
- In the Change Type with Locale dialog box:
- To change the destination data type, select a Data Type. (?Accounting?)
To change the locale, select a Locale. (US.-EN) - Click OK.
If the preview looks ok [Close & load].
https://support.microsoft.com/en-us/office/internationalization-power-query-d42b9390-1fff-413f-8120-d7df0ced20b9
Expand: Use a non-default locale setting on a Change Type operation
6 Replies
Excel Try this:
Select column B
Ctrl-H (Find & Replace)
Find: $
Replace with: leave blank
Press "Replace all"
OK
Close
Thank you sir so much sir😊😊
If your computer is running an US's system this should do the trick:
=VALUE(B2)
If you use other national settings its easiest to use powerQuery (guessing the translation )
Data->fetsh an transform->from table/intervall
DataType->??????
Hmmm, where are the national settings? They used to be there 😞
How i will do that with the help of power query? Please explain
select a cell in your "data table" and go to:
Data->Get & Transform->Table/Range
This is from the microsoft page linked below. Bold text = my guessing of relevant settings
- Right-click a query column.
- Click Change Type > Using Locale.
- In the Change Type with Locale dialog box:
- To change the destination data type, select a Data Type. (?Accounting?)
To change the locale, select a Locale. (US.-EN) - Click OK.
If the preview looks ok [Close & load].
https://support.microsoft.com/en-us/office/internationalization-power-query-d42b9390-1fff-413f-8120-d7df0ced20b9
Expand: Use a non-default locale setting on a Change Type operation
