If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problem with a simple formula
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 |
#2
|
|||
|
|||
Problem with a simple formula
Hi
The cell is formatted as text, clear the cell and reformat as general, now your formula will work. HTH John "ChristiW26" wrote in message ... 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 |
#3
|
|||
|
|||
Problem with a simple formula
Sounds like the cell is formatted as TEXT. Change the format to GENERAL.
Then, double click in the cell (or hit function key F2) then hit Enter. -- Biff Microsoft Excel MVP "ChristiW26" wrote in message ... 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 |
#4
|
|||
|
|||
Problem with a simple formula
did you set up the cell as text? if so delete what is in that cell, and set
the cell to general "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 |
#5
|
|||
|
|||
Problem with a simple formula
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 |
#6
|
|||
|
|||
Problem with a simple formula
Hi
Your formula should be =sum(range) Would you try go to Tool on the menu bar select Options select the View tab unclick the Formulas under the Window options -- Hope this help Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis "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 |
#7
|
|||
|
|||
Problem with a simple formula
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 |
#8
|
|||
|
|||
Problem with a simple formula
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 |
#9
|
|||
|
|||
Problem with a simple formula
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 |
Thread Tools | |
Display Modes | |
|
|