This is a common question, but no quick Excel solution normally works. There's a quick tutorial regarding a UDF and some VBA that seems to be a good fix:

http://www.eileenslounge.com/viewtopic.php?f=27&t=12298