| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Values won't display after altering a formula.
I am using a Vlookup function that displays the value in the formula drop
down boxes but only displays the formula in the cell when completed. |
|
#2
|
|||
|
|||
|
The cell was probably formatted as Text *before* you entered the formula
itself. Try this on a "bad" formula cell, Select the cell, then: <Ctrl <Shift <~, Then<F2, Then<Enter. What you did here was, Keyboard shortcut to re-format the cell to General, Then re-entered the formula. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Mike O" <Mike wrote in message ... I am using a Vlookup function that displays the value in the formula drop down boxes but only displays the formula in the cell when completed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you display the values of variables within an Excel formula | Excel Discussion (Misc queries) | |||
| Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
| Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
| How to display the "values" included in a formula vs. the cells? | Excel Worksheet Functions | |||
| Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Hybrid Mode
