I have used a vlookup to search a file and find a result and if I llok at the
formula it shows the value I expected, but displays The number 0 in the Cell.
How can I fix this:

For better answers, post your vlookup formula
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Hohner" wrote in message
...
I have used a vlookup to search a file and find a result and if I llok at
the
formula it shows the value I expected, but displays The number 0 in the
Cell.
How can I fix this:

Hi,
Without seeing your formula, the only thing I can think of is that the cell
is formatted incorrectly.
Format the cell as general, or an appropriate format for the data type you
expect in the cell.
Regards - Dave.