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!
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.