Reverse sign of number using Cell format

[ackey]

Morning all

I have been asked to help someone on a spreadsheet. He needs to reverse the sign of a number, but only the display or format, not the actual value. For example '-50' would display as '50', but still calculate as '-50'. In the same way '300' would display as '-300'

Have been through all the custom formats, and attempted my own, but with no success unfortunately

Thanks in advance

Simon

 

[onlyadrafter]

Hello,

format as

-#;#

 

[pgc01]

Hi Simon

Create a custom format, for ex.:

-0.00;0.00;0.00

Adjust for the decimals and thousands separator.

 

[ackey]

Excellent, both work perfectly of course

Thanks for your help

 

[cogswel__cogs]

Could this be done but have the postive displayed as negative be in brackets?

 

[MARK858]

Maybe...

"["0.00"]";0.00;0.00

or

\[0.00\];0.00;0.00

 

[cogswel__cogs]

Many thanks

 

[MARK858]

You're welcome