Custom Formats (Removing the percentage symbol)

[JimbobmiJ]

Hi Guys,

I'm trying to set up custom formats in the personal.xls. I have already attached a macro to a button to format a number to display positive numbers by thousandths and place brackets - in red - to display negatives.

The other format I want to setup is the same as the above but with percentages - display a positive percentage without the percentage symbol and display negative numbers in brackets without the percentage symbol.

I want to be able to use this on different reports (hence macro to the personal workbook).

I have scanned the posts and cannot see if the percentage issue has been solved.

Is there a VBA solution to this?

Thanks,

 

[donrgalletta]

One workaround is to copy and paste into an editor:

1. Copy column with the % values.
2. Paste values into an external editor
3. In the external editor, Find %, Replace (empty)
4. Copy values
5. Paste back into Excel document.