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

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

„(E-Mail Removed)â€� 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