Nov 06 2020 05:13 AM
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?
Nov 06 2020 06:33 AM
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 :(
Nov 06 2020 07:03 AM
How i will do that with the help of power query? Please explain
Nov 06 2020 07:59 AM
Solutionselect 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
If the preview looks ok [Close & load].
Expand: Use a non-default locale setting on a Change Type operation
Nov 06 2020 12:42 PM
@Excel Try this:
Select column B
Ctrl-H (Find & Replace)
Find: $
Replace with: leave blank
Press "Replace all"
OK
Close
Nov 06 2020 10:00 PM
Thank you sir so much sir:smiling_face_with_smiling_eyes::smiling_face_with_smiling_eyes:
Nov 06 2020 10:00 PM
Nov 06 2020 07:59 AM
Solutionselect 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
If the preview looks ok [Close & load].
Expand: Use a non-default locale setting on a Change Type operation