Convert text to number

[JGSmith123]

Hello

I have a column of numbers that was imported as a text. I wanted that changed to a Fixed Decimal Number. This needed to be the case in 2 columns. 

In both columns every cell converted appropriately except for the first cell. They both say "Error". 

When I click on the Error to see what they problem is, I receive this notice:

DataFormat.Error: We couldn't convert to Number.
Details:
     24.80%

I have done nothing different to this cell from any of the others below it. 

I have deleted the Data and re-entered it but I keep getting the same problem. The data comes from a website and you can see it here: http://www.barrons.com/articles/best-100-hedge-funds-for-2015-1431743869

I have looked through everything I can find in the help pages that deals with converting Data Types but I have yet to find my answer. 

Would anybody be able to point me in the right direction to find out how to fix this?

Thank you very much for your help

You can see a screenshot of what I am referring to here:

[ankitpatira]

@JGSmith123 first row has value '24.80%' where '%' is blocking it to be converted to a number. You can simply do replace values in power bi desktop query editor and remove '%' sign and that should work.

[JGSmith123]

Thank you very much for your response!

Here is a picture of me trying to do just that but I keep getting an error message saying that I need to enter a numerical value.

[Eric_Zhang]

---

@JGSmith123 wrote:

Thank you very much for your response!

Here is a picture of me trying to do just that but I keep getting an error message saying that I need to enter a numerical value.

---

@JGSmith123

Undo the "Changed Type" step (namely revert this column from decimal to text) and then replace the "%" with blank.

I've also noticed that there're more invalid rows appended. Do remember to uncheck them.

[Vvelarde · Accepted solution]

@JGSmith123

Replace "%" before to convert to number the columns.

A guide:

Step 1:Step 1: Edit QueryStep 2: First row as headerStep 3: Delete first rowStep 4: Replace %Step 5: Convert to NumberStep 6: Ready