View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Characters Qualifying a formula

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

On Thu, 23 Aug 2007 15:38:01 -0700, Tevuna
wrote:

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?