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

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

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

Hi Clive,

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


HTH
Cheers
Carim