Home > Support > Hints and Tips > Tip of the Week

Weekly Computer Tip # 32
21 September 2003

Start each week with a free tip

To subscribe, please type your email address in the box below:

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.

Email this page to a friend

Enter recipient's email address in the box below:

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  

© Roem Ltd. All Rights Reserved
September 2003