Weird Number in Excel 2003

M

Marilyn

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

Mike H

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
 
T

Tim879

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.
 
S

Sheila D

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
 
Top