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

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.

On Sep 3, 9:16 am, Kmurray wrote:
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.

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.

"Spiky" wrote:

On Sep 3, 9:16 am, Kmurray wrote:
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.

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.

On Sep 3, 10:08 am, Kmurray wrote:
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.

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.