Assuming that the first value (-120) is in cell A2.

Insert following formula in B2:-
=IF(A2=0,A2,"")

Insert following formula in C2:-
=IF(A2<0,A2,"")

Copy the formulas down.

Note: The first formula will include zero as a positive.

--
Regards,

OssieMac


"srpavar" wrote:

I have numbers in column A like this
A B C
-60.0 -60
-60.9 -60.9
55.0 55
-63.7 -63.7
25.0 25
-71.0 -71
35.0 35
I need to sort out only negative numbers in column C and Positve numbers to
Column B using some formula or function, can anyone help me in this i will be
really grateful. Thanks