Convert (-) to a (+) number Macro
Thanks - that was easy
"Mike H" wrote:
Hi,
You probably don't need a macro. Put -1 in a cell and copy it. Select the
number(s) to convert and then
Edit|Paste Special - Select 'Multiply' - OK
Delete the -1
Mike
"Nikki" wrote:
Does anyone know what macro I could use to convert a (-) number to a (+)
number? For example, I have -8.96% and need to change it to 8.96% to show a
negative $ amount in my calculation. All I need is to remove the (-) symbol.
|