# remove percent sign

#### sd101

##### New Member
Hi all -
How do I remove the percent sign from % formatted cells without altering the formulas? I feel this should be possible through the format dialog, with a custom "format code" of some sort -- thanks for your help!

sd

### Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Clear, Formats

Thanks, but I want to remove the percent sign, not also change the value in the cell. To reiterate,

before
1.20%

after
1.20

this is a calculated cell, and the formula must be the same before and after (so I can't just multiply by 100)

what formula are you using to get the 1.2% ??

Custom number format: #.00
Book1
ABCD
12002401.20
Sheet1

I had no idea this would be so difficult -- apologies. Here is the setup:

The formula is a combination of other cells, and returns the numerical value of:

0.012

When I format it as a percent, the actual numerical _value_ in the cell (which is referenced later on in the sheet) remains 0.012, but on the screen and when printed, it appears as:
1.20%.

What I need:
It should retain the value 0.012 (so it doesn't mess things up later on) but when printed, it should look like:
1.20

(the problem is I've got a whole bunch of these, and the % signs clutter the printout, making my boss unhappy...)

Thanks everybody!

You have kinda strangled your options because of your

this is a calculated cell, and the formula must be the same before and after (so I can't just multiply by 100)
comment. You cannot format a cell to display as a % without a % sign. You have to change the value, which means adjusting your formula to include a *100 on the end (or similar adjustment).

As Oaktree states, you must remove the percentage formatting to get the result you want. The formula will still give you the percentage when adding *100 at the end of your formula.

For example:

If you want to show two decimal places, =ROUNDUP((B1/A1)*100,2)

Ron

Formula in D1 is: =TEXT(C1*100,"#.00")
Book1
ABCD
120,0002401.20%1.20
2Hide thisShow
3column.this
4It can stillcolumn
5be used for
6calculation.
Sheet1

Hi sd

I had that exact problem in another context. Since I did not find an excel solution I used a windows solution.

I simply edited the font I was using, replaced the % sign with nothing and saved it with another name.

Then I just had to select that font for the cells that used the format with the percent sign. Excel thinks that the % is being displayed but, in fact, it's not because the new font displays the % as nothing.

Notice that this is only to be used as a last resource solution. If you'd want to work with the workbook in another computer you'll have to install the new font.

Hope this helps
PGC

Replies
0
Views
110
Replies
13
Views
1K
Replies
9
Views
253
Replies
6
Views
162
Replies
9
Views
214

1,203,455
Messages
6,055,541
Members
444,794
Latest member
HSAL

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back