If the positive figure is in A1

=-A1

But I suspect it's more complicated than that???

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"judgejulz" wrote in message
...
How can I make all the cells in one column appear as a negative if they
contain a formula that inserts a positive figure?