If you format as a number as previously suggested then set data validation as
a list on the cell you are looking up for your Vlookup function you will get
a drop down list of valid entries to choose from.

Go to Data, Validation, choose List, then set the range of valid entries

HTH
Sheila


"Marilyn" wrote:

I have about 400 rows of information and some of my numbers display as:
1.0202E+12, however in the formula bar it looks like this:1020201010401.
I'm trying to create a VLookup and I keep getting a Value is not available
and I think it may have to do with the way the number displays. How can I
display what is showing in the formula bar without using an (').

Thanks,