Values won't display after altering a formula.

M

Mike O

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

Ragdyer

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Drop down list control value in vba 2
Display weeks from a Milestone 0
VLOOKUP & Data Validation 0
Help With VLOOKUP 2
Searching the formula (not the value) for a text string 1
Formatting Rule: Diplay Section based on Selection in another section 0
Multiply with Vlookup value from another Worksheet 0

Top