| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula is text, not resolving to an answer
when I type in a formula, by example =2+4 and hit enter, the cell displays
the text of =2+4 and does not resolve into a 6. How can I correct? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula is text, not resolving to an answer
Sounds like the cell is formatted to text. Reformat the cell to number and
type it in again. Format|Cell then select the number tab and choose number. "rahrah3a" wrote: when I type in a formula, by example =2+4 and hit enter, the cell displays the text of =2+4 and does not resolve into a 6. How can I correct? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula is text, not resolving to an answer
Try going up in the formula bar and deleting the equal sign and hit enter.....then replace the equal sign and hit enter again.......... Possibly the cell was pre-formatted as TEXT. Vaya con Dios, Chuck, CABGx3 "rahrah3a" wrote: when I type in a formula, by example =2+4 and hit enter, the cell displays the text of =2+4 and does not resolve into a 6. How can I correct? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula is text, not resolving to an answer
Thank you. Simply formating the cell to a number did not work, deleting the
equal and re-adding it worked perfectly. Thanks! "CLR" wrote: Try going up in the formula bar and deleting the equal sign and hit enter.....then replace the equal sign and hit enter again.......... Possibly the cell was pre-formatted as TEXT. Vaya con Dios, Chuck, CABGx3 "rahrah3a" wrote: when I type in a formula, by example =2+4 and hit enter, the cell displays the text of =2+4 and does not resolve into a 6. How can I correct? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula is text, not resolving to an answer
Happy to help, thanks for the feedback............
Vaya con Dios, Chuck, CABGx3 "rahrah3a" wrote: Thank you. Simply formating the cell to a number did not work, deleting the equal and re-adding it worked perfectly. Thanks! "CLR" wrote: Try going up in the formula bar and deleting the equal sign and hit enter.....then replace the equal sign and hit enter again.......... Possibly the cell was pre-formatted as TEXT. Vaya con Dios, Chuck, CABGx3 "rahrah3a" wrote: when I type in a formula, by example =2+4 and hit enter, the cell displays the text of =2+4 and does not resolve into a 6. How can I correct? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Sumproduct issues | Excel Worksheet Functions | |||
| Copy from a Cell to a text box. | Excel Worksheet Functions | |||
| Invisable text in formula bar | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
Hybrid Mode
