| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function displays as text, doesn't return result or error
When I export data from QuickBooks to an Excel spreadsheet, the function
feature appears to be turned off. I type a correct syntax function into a cell, preceded by an "=", formatted as "general" and with the "option" function view turned off, and the following is displayed instead of the result: =VLOOKUP(D2,Sheet2!A2:B11,2) Literaly, it just shows me what I typed. I KNOW there is a switch somewhere that QuickBooks turned off in this workbook... For the life of me I can't find it. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function displays as text, doesn't return result or error
You might have calculation mode set to manual - go to Tools | Options |
Calculation (tab) and ensure that Automatic is checked. Hope this helps. Pete |
|
#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 |
| Reply |
| 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 | |||
Linear Mode
