Excel doens't recognized a cell as a number

[Nighteg]

Hi everyone!
A quick question: i have a number (%) in the cell B3, which excel doesn't recognizes as a number.
Is there anything i can do "excel-wise", instead of manually rewritting the number in the cell, for excel to recognize it as a number.
Changing it to a "number" or "percentage" in the cell format doesn't help.
Thanks!

[sbehera]

Hi,there is a extra space after the "%". That's why the excel treating this as Text. get rid of that and it will be all fine.

[oeldere]

there is a space after the %.

so D5 =

Please Login or Register  to view this content.

[daddylonglegs]

The extra character is actually a "Char 160" character, not a "space" as such - you often get those if you copy from a website. You can eliminate those using

=2*SUBSTITUTE(B3,CHAR(160),"")

[Nighteg]

Thanks everyone

[icestationzbra]

http://office.microsoft.com/en-us/ex...003056131.aspx

refer to the post by bebo in the following link:

http://www.excelforum.com/excel-gene...-matching.html