How to display an equal sign in Excel

Monday, June 29th, 2009
Advertisement

Subscribe.
Enter your email:

The equal sign is a special sign used to indicates that we are typing a formula in a cell. It will never be shown in a cell. But, is it possible to display the equal sign in Microsoft Excel?

Actually you can display the equal sign. What you need to do is just add an apostrophe in front of the equal sign, like this:

'=

Once you press Enter, the apostrophe will disappear, leaving the equal sign.

Note: To display the apostrophe, just enter the apostrophe twice.

If you are new here, you might want to subscribe to the RSS feed or newsletter.

Enter your email address:

Creates the exact copy of your hard disk and allows you to instantly restore the entire machine.
New Acronis True Image Home 2010 is the most reliable and easy in use backup solution. Now with online backup option!
15% Discount Code: FMAATIH2010

What else?

Like this article? Share it

 Digg  del.icio.us  TwitThis  Facebook  Reddit  StumbleUpon

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>