Hi,

Assuming your data is in column A, then just put into column B
=IF (A1=0,A1,"")
and in column C
=IF(A1<0,A1,"")

Or put whatever else you want as the third parameter.

HTH,

David Jessop

"jez123456" wrote:

Hi, I have an excel spreadsheet with 4000 rows. Sample data from the Amount
column is as follows:

Amount
£0.00
£400.00
-£20.00
-£20.00
£100.00
-£50.00
-£8.99
-£44.57
-£30.00
-£9.39
-£20.00
£100.00

Is there a quick way to seperate this data into positve and negative amounts
to give:

Credit Debit
£0.00
£400.00
-£20.00
-£20.00
£100.00
-£50.00
-£8.99
-£44.57
-£30.00
-£9.39
-£20.00
£100.00

Many Thanks