Adding negative currency automatically
 

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

Adding negative currency automatically
 

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

Adding negative currency automatically
 

You can do that with this Change event sub:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 6 Then 'column F, adjust to No of your outgoings
column!
Target.Value = -Target.Value
End If
End Sub


Regards,
Stefi

€� ezt Ã*rta:

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

Adding negative currency automatically
 

Hi Clive,

Use Format Cell Number Custom
and enter your customised format, e.g. -$#,##0.00


HTH
Cheers
Carim