I have a co-worker that cannot use vlookup because of a stored text issue. He FWD'd the spreadsheet to me and I found that the cells were stored as text, but he cannot see this on his computer. Is there a setting on excel that will show cells stored as text in order to correct and complete the vlookup formula?