Forum Discussion

Excel's avatar
Excel
Iron Contributor
Nov 06, 2020
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?
  • MindreVetande's avatar
    MindreVetande
    Nov 06, 2020

    Excel 

    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

    1. Right-click a query column.
    2. Click Change Type > Using Locale.
    3. In the Change Type with Locale dialog box:
    4. To change the destination data type, select a Data Type. (?Accounting?)
      To change the locale, select a Locale. (US.-EN)
    5. 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

Resources