Put -1 in an empty cell, copy it, select the positive numbers and do
editpaste special and select multiply. This will of course change the
number to a negative but I am not 100% sure what you want?


A formula would look like

=-A1

--


Regards,


Peo Sjoblom



"Vanessa" wrote in message
...
Is there a way or a function to change a positive number you get by
applying
a formula to a negative number, so you can have it displayed with
brackets.