Put something like this in B1
=if(a1<0,a1,"")
and in C1
=if(a1=0,A1,"")

and drag down.

I'm not sure how 0's should be treated, though


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

--

Dave Peterson