I can't figure out what is going on here. I have a bunch of phone numbers in a column and am trying to do a Vlookup. The formula keeps giving me an N/A. However if I manually type over inside the cell the numbers then the formula works. There are 240 lines so I can't do that for every line. Anyone have a workaround?