Sepatate positive and negative numbers

  • Thread starter Thread starter Joe Soap
  • Start date Start date
J

Joe Soap

Hello

Is it possible to automatically separate positive and negative numbers
(precedeed by a minus sign) from one column into two different columns ?

I'm using Excel 97.

Thank you

Joe
 
If you have your list of numbers in Col A starting in Row 1
Put this formula in B1 =if(A1>0,A1,"") for pos #'s
Put this formula in C1 =if(A1<0,A1,"") for neg #'s

Copy the two formulae down as far as needed
Note that zero will not show in either col B or
 
Back
Top