I guess you could put =IF(A1=0,A1,"") in one column for the +ve numbers and
=IF(A1<0,A1,"") in the next column for the -ve numbers and copy both down to
your last entry

"Prospect" wrote:

I have a large column of numbers, some postive and some negative. I would
like to separate these into two columns, one for positive and one for
negative. Is there a quick way of doing this?
--
David