Also the function of LEFT() makes the number text, multiply it by 1 to
turn it back to a true number.

=LEFT(A1,2)*1

Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=513757