Converting Numbers to negative

[les.61]

Do you know if you can use the cell formatting to change the sign of a number? For example, the cell contains 123.45, but I want it to show as -123.45. I don’t want to use a formula to multiply by -1, because the data is being extracted from a database and I have to do a fair amount of work on the report with the formulas to do that.

I can format the number and it shows a minus but will not use the minus if I then use it in a calcualtion. I could use a calcualtion with a *-1 in it but for ease of use by other users who may take part of the Excel report it would be better if I could format the number to negative.

 

[Scott Huish]

BTW, you don't have to do *-1

adding the negative sign before the number will negate it:

=A1*-1

and
=-A1

will return the same result.

What is the formula you are looking to use?

 

[Schubox99]

Just joined today searching for this! Thanks!