| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula remains as text rather than formula
the formula remains as text in the field
ie ='filetracker'!C26 This only happens occasionally - anyone know why? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula remains as text rather than formula
If the cell is formatted as text, this will happen. Change to genera
and reenter the formula and it should work. -- Message posted from http://www.ExcelForum.com |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula remains as text rather than formula
If the formula references a cell that is formatted as text this can also
happen. -- Regards, Tom Ogilvy "kkknie " wrote in message ... If the cell is formatted as text, this will happen. Change to general and reenter the formula and it should work. K --- Message posted from http://www.ExcelForum.com/ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula remains as text rather than formula
-----Original Message----- If the formula references a cell that is formatted as text this can also happen. -- Regards, Tom Ogilvy "kkknie " wrote in message ... If the cell is formatted as text, this will happen. Change to general and reenter the formula and it should work. K --- Message posted from http://www.ExcelForum.com/ . Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping excel from performing subtraction so text remains as is | Excel Discussion (Misc queries) | |||
| How do I creat a math formula that remains in Excel. | Excel Worksheet Functions | |||
| Entering a Formula; Remains a Formula Instead of Calculating | Excel Discussion (Misc queries) | |||
| Valid formula remains in cell | Excel Discussion (Misc queries) | |||
| How do I copy a formula in excel where part remains absolute the . | Excel Discussion (Misc queries) | |||
![Sandi[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
