Forum Discussion
Quetion related to convert text into number
- Nov 06, 2020
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
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 😞
- ExcelNov 06, 2020Iron Contributor
How i will do that with the help of power query? Please explain
- MindreVetandeNov 06, 2020Iron Contributor
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
- ExcelNov 07, 2020Iron ContributorThank you so much sir😊😊