Remove % and return only integer value

Hi All,

I have a row where in the values enetered are in %..

like

Please Login or Register  to view this content.

i am using the below formula in other cell to get these values

Please Login or Register  to view this content.

now the problem is, this will return the value by deviding it by 100..like below

Please Login or Register  to view this content.

but i want a result like below without % symbol.

Please Login or Register  to view this content.

also if there is any blank cell in the input then the resultant cell should also show a blank cell..

Please help

Thank you

Originally Posted by vlady

maybe multiply it by 100


=IF(INDEX($1:$1,ROW(A1))="","",(INDEX($1:$1,ROW(A1))*100))

Strange!!

I did the same before which didnt work (may be i was missing something before).. but now after u gave this formula, it is working like a charm

Thanks a lot..