/ character causes menu bar to be active

[jaustin]

Can anyone tell me why when I open an excel document and enter the "/"
character into a cell, the character does not appear but the menu bar becomes
active. How can I avoid this from happening?

Thanks,

 

[Caroline]

You could put a single speech mark (') infront of the / - the ' will
disappear, but leave the / in the cell.

 

[Andy Pope]

Hi,

Check the setting of Tools > Options > Transition > Microsoft Office Excel
Menu Key.

Entering a single quote first stops the menu key from working.

Cheers
Andy

 

[jaustin]

I found the answer in another thread. I went to Tools - Options - Transition
tab and set the Menu Key from / to spaces.

Thanks,