Hi Ardus,

it's not a text value, it's just the way I formatted the cell. If I run my macro again, it will convert it back to normal. Here is the marco so you can see :

Sub Show_Paid()
If ActiveCell.NumberFormat = "#,##0.00" Then
Selection.NumberFormat = "< #,##0.00 >"
ElseIf ActiveCell.NumberFormat = "< #,##0.00 >" Then
ActiveCell.NumberFormat = "#,##0.00"
End If
End Sub


DL : I tried a second column but it's messy - I have my columns as Jan, Feb etc with carry forward balances and so to work over 2 columns is a pain.

What I am hopeing to get is a nested SUB (IF) statement that can identify the formula type and then not add up the <> ones. I am struggeling to find a format command in Excel though( plenty in VBA)

thanks
Steve