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!