|
|
|
|
#1
06-04-2018, 01:29 PM
|
|||
|
|||
One cell was formatted as text
|
|
#3
06-04-2018, 01:39 PM
|
|||
|
|||
|
Okay, if I typed a formula in a cell and then changed the format to text afterwards, the result is displayed. However, if I change the format to text before I typed the formula in, the formula is displayed. I would think it should work the same either way, but at least I know a way to do this now. Thanks.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Formula result not displaying in cell (but f9 works)
|
nath1235 | Excel | 4 | 10-06-2017 12:42 PM |
| Perform calc in active cell then highlight based on formula result | grexcelman | Excel Programming | 4 | 01-12-2015 11:00 AM |
|
Show result of formula as a value in another cell
|
Steve_D | Excel | 4 | 10-12-2014 07:38 PM |
|
If formula result is negative then display text
|
oxicottin | Excel | 3 | 12-03-2012 02:12 AM |
| Can I create a formula that will show result in the same cell and let me copy it down | CranstC | Excel | 1 | 02-11-2012 01:29 AM |
Windows 8 
Office 2016
Hybrid Mode