Conditional if statement for numerical value

[excel_vb]

I'm struggling to write a conditional if statement in vba.
I have a file which needs to be converted to a particualr format.
The file contains accounts and amounts in specific cells.
For all account numbers that begin with 1 ( eg 103067, 121256), I want the amounts to remain intact.
For all accounts that begin with 2( eg 250466,203093) I want the amounts to be multiplied by -1.
Every month, the file will have different account numbers in those cells, so I cant record a macro to acheive this.
How do I write code for this?

---------------------
Thats a great place for me to start...thanks so much!

[rylo]

Hi

You will have to change the cell selection method, but something like this.

If Left(ActiveCell.Value, 1) = "2" Then ActiveCell.Value = -ActiveCell.Value

HTH

rylo