if the number is in b5 then try this for size

=IF(ISNUMBER(FIND("B";B5))=TRUE;LEFT(B5;FIND("B";B 5)-1)*1000000;IF(ISNUMBER(FIND("M";B5))=TRUE;LEFT(B5; FIND("M";B5)-1)*1000;B5))

:)


--
nijunge
------------------------------------------------------------------------
nijunge's Profile: http://www.excelforum.com/member.php...o&userid=26404
View this thread: http://www.excelforum.com/showthread...hreadid=398977