Disregard my formula. FIXED still rounds up. TRUNC or ROUNDDOWN would
be what you are looking for. Sorry for the erroneous post. The Text
to Columns solution would work as well.


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=562206