Formula returns 0

[cwillberg]

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

[Jerry W. Lewis]

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