Characters Qualifying a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Usually all formulas start with an equal sign (=) Other characters too have
some special meaning in that when entered instead of the equals sign, Excel
entered the equals by its self and, sometimes, removes that character. For
example minus, plus, or @.
Is a list of all meaningful character available somewhere?
 
On my Excel 2003 entering -A1 turns to =A1, +A1 turns to =+A1

@A1 tells me "not a valid function"

The list is probably complete as above.

I can find no others by experiment.


Gord Dibben MS Excel MVP
 
Your eyes are better than mine.

Tried again and adjusted the bifocals.

=-A1 is what I see upon closer inspection.

Thanks David


Gord
 
Back
Top