Formula returns 0
 

Hi,

I am using some basic of formulas, SUM and MAX, within a large file
have started to give 0 as an answer even when this is not the true
result. The same formulas were working previously but have now stopped.
I'm not sure if i have change some display setting, but I don't seem to
be apply to get them to return to how they where.

Any help would be greatly appreciated
Chris


--
cwillberg
------------------------------------------------------------------------
cwillberg's Profile: http://www.excelforum.com/member.php...o&userid=34765
View this thread: http://www.excelforum.com/showthread...hreadid=545260

Formula returns 0
 

What does COUNT(range) return? If zero, then the data in your cells are
character strings that only look like numbers.

Jerry

"cwillberg" wrote:


Hi,

I am using some basic of formulas, SUM and MAX, within a large file
have started to give 0 as an answer even when this is not the true
result. The same formulas were working previously but have now stopped.
I'm not sure if i have change some display setting, but I don't seem to
be apply to get them to return to how they where.

Any help would be greatly appreciated
Chris