| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SOLVED!: Function displays as text, doesn't return result or erro
Apparently, the cell I was referencing for the lookup value was formatted as
"text," so Excel "helpfully" auto-formatted the cells containing the referencing functions as "text." Voila! typed formula instead of a result. I went back and made sure that all reference cells were formatted GENERAL. Life is good again... "Pete_UK" wrote: You might have calculation mode set to manual - go to Tools | Options | Calculation (tab) and ensure that Automatic is checked. Hope this helps. Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding "and" to Spellnumber code | Excel Discussion (Misc queries) | |||
| Displays the number in text. (One thousand two hundred thirty four | Excel Worksheet Functions | |||
| Number format | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
| Amount or Numbers in Words | New Users to Excel | |||
Threaded Mode
