Above 9 try formatting as text

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"lloyd" wrote in message
...
I have a 12 digit number in one area and doing the vlookup seems to be only
looking at the first 6 and rouding at that point. I need the lookup to
look
at the entire 12 characters and do a match on all 12.