Hi
your numeric values are probably stored as 'Text' values (have you
imported them?). Try the following to convert these values back to real
numeric values:
- copy an empty cell
- select your values
- goto 'Edit - Paste Special' and choose 'Add'

--
Regards
Frank Kabel
Frankfurt, Germany

"Frustrated User of Excel today" <Frustrated User of Excel
schrieb im Newsbeitrag
...
Why won't Excel calculate formulas on this spreadhseet. It's acting
like
there is no data in the cells. We are putting in =Average(B2:B286)
and doing
this in each column from column B - P for average and median. Its'
returning
#DIV/0! Three very good Excel people here have tried. Why is it not
calculating data? We noticed that when we typed the value back into
one or
two cells in "B" that it calculated a median and average. So, why
buy
software if I have to type in values from B - P from 2 - 286!!??? Why
won't
Excel calculate this? What's the answer to get it to recognize the
data that
is in fact there. The formulas are correct also!!!!!!!!!!!!!!