Forum Discussion
Quetion related to convert text into number
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
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
- Thank you so much sir😊😊