A
Access Joe
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!
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!