I've created a database with parts that have a - prefix before the
actual part number but it is returning n/a. It works fine if I don't
use a dash. Is there a way around this?

example

-04
-06
-08
-3


--
MrSales
------------------------------------------------------------------------
MrSales's Profile: http://www.excelforum.com/member.php...o&userid=32572
View this thread: http://www.excelforum.com/showthread...hreadid=546909