Do you want to count them?

Do you want to list them?

Do you want to convert them to positives?

IF(A1<0,"neg","not neg") will label them

using conditional formatting, you could change the cell font to red

I will try to help further when you say what you are trying to do.

Bobf


--
bob777
------------------------------------------------------------------------
bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=504791