How to display an equal sign in Excel

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.