In Excel when we enter numbers, the value appears as # in cells Whats the keyboard shortcut to resolve this matter other than mouse?

ALT + H + O + I - Excel2007

ALT + O + C + A - Excel2003

Good question, and to be honest never used it. the Alt O C A works in Excel2013 version as well as the Alt O invokes the earlier versions of excel shortcuts.