Forum Discussion

janez599's avatar
janez599
Regular Visitor
9 years ago
Solved

Please Help: change data type from text to decimal number

Hi there, I am new to Excel and Power BI Desktop. I am using a text file with many columns to analyze our website traffic. One of the columns is click-through rate was imported as a text. I wanted tha...
Tips and Tricks
  • Daniil's avatar
    Daniil
    9 years ago

    There are several steps involved:

     

    1. Right-click the column, select Replace Values...


    2. Replace the % symbol with nothing


    3. Change Type to Fixed Decimal Number


    4. Since this is a percentage, you need to divide by 100


    5. Finally, you get the desired result
Daniil's avatar
Daniil
Icon for Kudo Kingpin rankKudo Kingpin
9 years ago

There are several steps involved:

 

  1. Right-click the column, select Replace Values...


  2. Replace the % symbol with nothing


  3. Change Type to Fixed Decimal Number


  4. Since this is a percentage, you need to divide by 100


  5. Finally, you get the desired result
  • janez599's avatar
    janez599
    Regular Visitor
    9 years ago

    Thanks a lot Daniil for your detailed instruction!

  • Kapilkumar's avatar
    Kapilkumar
    New Member
    2 years ago

    i have data of sales  in the format let say

    $1,00,12,223.00

    $2,99,23,223.00 

     and so on of 700 rows and whenever i load the data and see it in query exditor then it showing its data type as ABC text 

    i tried few times but could not able to change it 

    please help!

    Daniil 

    janez599 

    PowerBI