Excel cell displays formula instead of result 1

[BruceG]

On a colleague's machine, we were trying to do a LEFT function in a cell (i.e. in B2, "=LEFT(A2, 6)&quot. In B2, the formula was displayed, not the result. The same thing happened when we tried MID. I did the same thing on my machine and it worked fine. Apparently my colleague's Excel must have some funky setting, but we couldn't find it. Any ideas? Thanks.

 

[Loomah]

Hi
go
TOOLS>OPTION VIEW tab and see if formulas is ticked.

Shortcut is CTRL+`

;-)

If a man says something and there are no women there to hear him, is he still wrong?

 

[Voga]

Bruce,
Try to do following:
On your friends computer:
Sience Lift, Mid, Right a VB functions :Open code window (Design window) then go to "Tools" then "References" Make an appropriate reference (Refer to Visual Basic) and then try it again. Same if you have database connection problem.
Good luck.
Voga

 

[BruceG]

Loomah, that was it, thank you very much.
Thanks also, Voga, for your response.