One other thought. Please ensure the formula doesn't have a ' prior to the =.
that will also force text formatting.

"Tom Hutchins" wrote:

Could there be a space or an apostrophe before the equal sign? That would
cause the cell to be treated as text, and the suggestions to change the
format to General wouldn't fix it.Select the cell, and in the formula bar
make sure there is nothing preceding the equal sign.

Hutch

"ChristiW26" wrote:

I've tried all of these things already, and again after your suggestions and
still not working... When I switch back and forth between the formula
display mode and regular all the cells are simply stretched and anything done
to them, like wrapping of text, is undone. The formula is still displayed in
the cell either way. I'm at a loss! lol

"Tom Hutchins" wrote:

The cell may have been formatted as text before you entered the formula.
Select the cell, then right-click and select Format Cells. In the Format
Cells dialog that appears, change the format to General or any number format,
then click OK. Press F2, then Enter.

Another possibility is that you have switched to formula display mode. This
mode displays the formulas in all cells instead of the values returned by the
formulas. It is toggled on/off by pressing Ctrl ` (the ` key is next to the
number 1).

Hope this helps,

Hutch

"ChristiW26" wrote:

I've entered a simple "=sum" formula into a cell on a worksheet and for some
reason, the formula is being displayed in the cell instead of the value.
I've used this formula countless times before and have never had this happen.
I've checked everything I know to check and I'm just at a loss. Anyone have
any advice?

Thanks,
Christi