| 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. |
| 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
