Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

Only Keyboard shortcut combination is required.!

user-image
Question added by Mukkaram Siddique , Finance, Management & Stocks , Amazon Foods Saudi Arabia
Date Posted: 2014/04/22
Atif Tanveer
by Atif Tanveer , Decision Support Specialist , Hamilton Health Science

ALT + H + O + I - Excel2007

ALT + O + C + A - Excel2003

Deleted user
by Deleted user

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.

Rahul kumar Rahul
by Rahul kumar Rahul , SAP EXECUTIVE , APTARA TECHBOOKS

null character/DAta mismatch

Gaone Mookodi
by Gaone Mookodi , Procurement Officer , Third Market Pty (Ltd)

press Alt key followed by F1key

More Questions Like This