Hello,

I have a column that displays the following:
53.0%
58.4%
54.4%
62.2%

However, the ACTUAL numbers (when I click on the cell), say:
52.9656352569444%
58.377172744889%
54.3782086879941%
62.1577477985649%

They have been formatted as 'Percentage' ... hence the reason for the above
display. What I want to do is JUST remove the % symbol only, but still keep
the display as it is. So the final result I'm looking for is:

53.0
58.4
54.4
62.2
(the numbers above minus the % sign)

I've tried changing the format to Number, tried tweaking the decimal
precision, tried Find/Replace, tried 'Text to Columns', and still nothing.
Can anyone help?

Thanks so much!