98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

Hints and tips home » Excel hints and tips » Using an equal (=) sign that isn't part of a formula

Using an equal (=) sign that isn't part of a formula

Before you type the equal sign, type an apostrophe: '
Then type your equal sign: = (and anything else you want to add after your equal sign)
Press ENTER.

(the apostraphe will disappear

Added by Meenesh on 3rd October 2006

More Excel hints and tips, like:

• Make macros work in newer versions of Excel
• Get to the end of the used range
• Quick Absolute Cell References