Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula won't calculate...
I copied a sumif formula accorss a worksheet, and then tried to make some
changes to the formula in one of the cells. When I made the change, the formula discontinued working and became text . For example, I typed the following in the cell: =2+2 The result was =2+2, not 4 as it should have been. I know the cell is formatted as text. Why did this happen? What prevents a formula from changing automatically to text? Many thanks.. -- Tom |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula won't calculate...
Because the cell is formatted as text, anything entered into that cell-
including what would be a formula anywhere else- is treated as text. This can be a tool (for instance, to display a formula, or to enter telephone numbers or zip codes) or a hindrance (what shows onscreen will sort alphabetically instead of numerically). |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula won't calculate...
Since it's a hindrance to what I'm trying to accomplish, how do I stop it
from happening? -- Tom "Dave O" wrote: Because the cell is formatted as text, anything entered into that cell- including what would be a formula anywhere else- is treated as text. This can be a tool (for instance, to display a formula, or to enter telephone numbers or zip codes) or a hindrance (what shows onscreen will sort alphabetically instead of numerically). |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula won't calculate...
Sorry for the delay, didn't see your post.
Change the format of the cells in question from text to numeric before copying. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate a formula once | Excel Worksheet Functions | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
Formula to calculate over-time | Excel Discussion (Misc queries) | |||
I need a formula to calculate the ratio of #'s in a row and column | Excel Discussion (Misc queries) | |||
X IN A CELL TO CALCULATE A FORMULA | Excel Worksheet Functions |