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.

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.

Format Cells... Number Accounting
--
Gary''s Student - gsnu200746


"Vanessa" wrote:

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.

Thanks, I think this might work. i am working with income statements and the
numbers you subtract have to be displayed with brackets around them and
Formating the cell as accounting does not do this since it only puts brackets
around negative numbers, but I have a positive number that I need changed.
Thanks again.

"Peo Sjoblom" wrote:

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.

Remember if you are going to subtract a negative number from a positive you
need to add it or else it will be added


--


Regards,


Peo Sjoblom




"Vanessa" wrote in message
...
Thanks, I think this might work. i am working with income statements and
the
numbers you subtract have to be displayed with brackets around them and
Formating the cell as accounting does not do this since it only puts
brackets
around negative numbers, but I have a positive number that I need changed.
Thanks again.

"Peo Sjoblom" wrote:

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.