wrote in message
ups.com...
Hello,

I've devloped a little spreadsheet to keep track of my finances.
In it all the columns are formatted to currency 2dp.

In the outgoings column I would like to insert a number and have it
automatically change to a negative currency. So basically I don't want
to press the - key each time i enter a value into that column. There
are no properties in the currency format to do this so I am stuck :-S

Any suggestions to how this can be done would be greatly appreciated!

kind regards,

Clive


I guess you need to use the change event for the cell and multiply the
content of that cell by -1. I'm a newbie so I cant tell you any more detail
though.

--
Chris Lewis