Forum Discussion
Solved
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
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😊😊
