how do Excel options need to be set to make formulas convert

  • Thread starter Thread starter Kmurray
  • Start date Start date
K

Kmurray

New problem I think it is associated with the Excel options.
In the past week I have been having issues with myVLOOKUP function.
Sometimes it will not change to reflect the answer. While writing the
formula, I can see the answer that should appear, but once I hit the ok
button, the formula is all that you see. I know this has to be something
simple that I don't see. I have looked at options for excel, but see nothing
that would stop the formula from hiding and the result appearing.
 
New problem I think it is associated with the Excel options.
In the past week I have been having issues with myVLOOKUP function.
Sometimes it will not change to reflect the answer. While writing the
formula, I can see the answer that should appear, but once I hit the ok
button, the formula is all that you see. I know this has to be something
simple that I don't see. I have looked at options for excel, but see nothing
that would stop the formula from hiding and the result appearing.
Click to expand...

Check to see if the cell is formatted as Text. Or press CTRL-`, see
what happens. Press it again if it doesn't help. The ` key is above
the Tab key on a USA keyboard.
 
I tried the CTRL ~ before, and it just widens the column to show the actual
formula like it normally would. Format is Text and I even did the data text
to columns to verify formatting. The same formula will work a couple of
columns over, makes no sense.
 
I tried the CTRL ~ before, and it just widens the column to show the actual
formula like it normally would. Format is Text and I even did the data text
to columns to verify formatting. The same formula will work a couple of
columns over, makes no sense.
Click to expand...

See, it shouldn't be formatted Text. Change that to whatever number
format you need. You may have to click in the cell and hit Enter again
after fixing the formatting to make it work.
 
Back
Top