Weekly Computer Tip # 32
21 September 2003

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

If you type an equal sign (=) in a cell, Excel automatically assumes that you're about to enter a formula. This is a logical assumption, since that's how all formulas begin. However,

Did you know ...

If you actually want to use an equal sign in your cell you can give Excel a clue that tells it you're not about to create a formula.

Here's how:

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

Please note that the apostrophe disappears.

Until next week.

PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.

Home   Training   Support   Clients   Contact Details   News   Disclaimer