Try formatting the cell as number.

Mike

"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,