Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Align dollar symbol, align currency symbol... | Excel Discussion (Misc queries) | |||
How can I remove the % symbol from a cell. Thanks | Excel Discussion (Misc queries) | |||
what shortcut key do I use for the + symbol over the - symbol | Excel Discussion (Misc queries) | |||
remove percent symbol on percentage formatted cells in excel | Excel Discussion (Misc queries) | |||
I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) |