How to remove the % symbol only
 

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!

How to remove the % symbol only
 

Type 100 in an unused cell.

Select and copy that cell.

Select your range to change and EditPaste SpecialMultiplyOKEsc.

Now format to General or Number with 2 DP

Delete the 100 cell.


Gord Dibben MS Excel MVP

On Tue, 10 Jun 2008 14:49:01 -0700, Access Joe
wrote:

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!

How to remove the % symbol only
 

YOU rock! That is awesome!

"Gord Dibben" wrote:

Type 100 in an unused cell.

Select and copy that cell.

Select your range to change and EditPaste SpecialMultiplyOKEsc.

Now format to General or Number with 2 DP

Delete the 100 cell.


Gord Dibben MS Excel MVP

On Tue, 10 Jun 2008 14:49:01 -0700, Access Joe
wrote:

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!

How to remove the % symbol only
 

Good to hear.

Thanks for the feedback.


Gord

On Tue, 10 Jun 2008 15:36:01 -0700, Access Joe
wrote:

YOU rock! That is awesome!

"Gord Dibben" wrote:

Type 100 in an unused cell.

Select and copy that cell.

Select your range to change and EditPaste SpecialMultiplyOKEsc.

Now format to General or Number with 2 DP

Delete the 100 cell.


Gord Dibben MS Excel MVP

On Tue, 10 Jun 2008 14:49:01 -0700, Access Joe
wrote:

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!