I am new to this so just checking to see if this was received


"lloyd" wrote:

When I do text formatting it appearing as 12452145E12

"Don Guillett" wrote:

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.