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
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