Format it as general, it is defaulting to a date.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Wzbell" wrote in
message ...

OK I tried the last formula by Bob Phillips and get a 1/0/00 response.
Any clue of what's going on?


--
Wzbell
------------------------------------------------------------------------
Wzbell's Profile:
http://www.excelforum.com/member.php...o&userid=37890
View this thread: http://www.excelforum.com/showthread...hreadid=574291