Hi,

You could try something like this:

=MAX(SIGN(A1),0)

so that your number is in A1.

- Asser


--
Jazzer
------------------------------------------------------------------------
Jazzer's Profile: http://www.excelforum.com/member.php...fo&userid=4464
View this thread: http://www.excelforum.com/showthread...hreadid=276583