anything in Excel...

It's Excel-o-lozy...

Keyboard error shift + 2 is ' rather than @ (number help)

www.Excelolozy.comWhen Shift key is held down and 2 is pressed then it shows ‘ (single quote) rather than @ (at).

This happens with all number keys that don’t work in combination with shift key. 

Reason:
This happens due to language settings of keyboard that is set as UK or some other one, instead of US.
  
Solution:
To solve this go to :
Control Panel > Regional settings > Key board settings > Change the keyboard from UK to US > then select all others Key board languages and click “Remove”.


Anything in Excel, be an Excelolozian...

for best MS Excel Tips visit http://www.Excelolozy.com

gotta query??? drop a mail at mail@excelolozy.com