Chances are that your sheet is set to display formulas, OR, the sheet is
formatted as text prior to you putting in your formulas.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Kerstin" wrote in message
...
When doing v-lookup from one spreadsheet to another, it displays the
formular
instead of the result. I pulled the first set of numbers out of a
database
and made sure they are all numbers, not text. The second set of data was
sent to me and seems also to be numbers.