Vlookup Returning Scientific Notation

[oscark37]

Using order numbers, I am using vlookup to find USPS tracking number for shipment. The tracking numbers are formatted as General and look like this ="92748999985581543478078036".

Unfortunately, it is not returning that number, but instead scientific notation. What is the easiest way to fix this please?

Thanks,

Oscar

 

[arthurbr]

Perhaps =text(VLOOKUP(...),"#")

 

[oscark37]

T

Perhaps =text(VLOOKUP(...),"#")

Thanks Arthur! That is getting me closer, but still not quite there. The tracking number is 92748999985581543478081692. Your vlookup formula is returning
92748999985581500000000000.

Any ideas?

 

[Norie]

Have you tried formatting the cell with the formula as General?

 

[oscark37]

The formula is formatted as general.

Have you tried formatting the cell with the formula as General?