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,

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,

I just read you post again. While my previous answer will resolve the way a
number is displayed it won't cure your vlookup problem because:-

1.0202E+12
1020201010401

may look different but are in fact the same number so would evaluate the
same as part of a vlookup.

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,

One other thing you can try is to use the Round () function to round
the number. I've had issues with Excel in the past where there will be
#'s in insignificant decimal places causing the lookups to fail.

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,