Sounds like the cell with formula is formatted as text. Try changing the
format of formula cells to general or number, then select cell, press F2, and
then Enter to recalculate.

If that doesn't help, make sure the cells with numbers are also not
formatted as text. I'm a little suspiscious since it looks like some are
left-aligned (usually used for text), and some are right-aligned (default for
numbers)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Salman" wrote:

Hi,
I am using Excel 97-2000. Exported some revenue figures from another system
called €˜DataExkavator into Excel. Although these are €˜numbers and not text
but I cant add them. I also tried to change them to numbers by using €˜value
function but its not helping either and showing the formula I typed rather
than displaying the calculation. Please see below:

Customer Name Cust Revenue Adj

ABC 109629.378 =value(B2)
DEF 33386.558 =value(B3)
GHI 2063.095 =B4
JKL 2798.695 =abs(B5)

Please advise. Your help will be highly appreciated. Thanks, Salman