Help with Strange Formula

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

and =SUMIF(A:A,"<0") for those in the brackets

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"scr5jo" <scr5jo.2ad3dz_1151917202.0847@excelforum-nospam.com> wrote in
message news:scr5jo.2ad3dz_1151917202.0847@excelforum-nospam.com...
>
> 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
>
>
> --
> scr5jo
> ------------------------------------------------------------------------
> scr5jo's Profile:
http://www.excelforum.com/member.php...o&userid=35990
> View this thread: http://www.excelforum.com/showthread...hreadid=557771
>

=SUMIF(A:A,">0")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"scr5jo" <scr5jo.2ad3dz_1151917202.0847@excelforum-nospam.com> wrote in
message news:scr5jo.2ad3dz_1151917202.0847@excelforum-nospam.com...
>
> 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
>
>
> --
> scr5jo
> ------------------------------------------------------------------------
> scr5jo's Profile:
http://www.excelforum.com/member.php...o&userid=35990
> View this thread: http://www.excelforum.com/showthread...hreadid=557771
>