"jez123456" wrote in message
...
Is there a quick way to seperate this data into positve and negative
amounts

How quick? In the first column to the right, use

=IF($A1=0,$A1,"")

& copy down. In the second column to the right,

=IF($B1="",$A1,"")

& copy down. Select & copy the 2 columns, then Edit -- Paste Special --
Values.

Rgds,
Andy