If I type a formula into excell, and forget the "=", the equal si.

[Guest]

If I type a formula into excell, and forget the "=", the equal sign should be
added automatically.

 

[RagDyeR]

Your opinion ?

 

[Don Guillett]

Lazy.
Right click sheet tab>view code>copy/paste this>save. Now if in row 4 or
below and in col A it will be automatic.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row < 4 Or Target.Column <> 1 Then Exit Sub
If InStr(Target, "*") Then Target = "=" & Target
End Sub

 

[Gord Dibben]

Will

How would Excel know you are typing a formula?

e.g. Type in Will & Holmes

How would excel know you wanted WillHolmes?

Gord Dibben Excel MVP

On Mon, 8 Nov 2004 08:55:04 -0800, "Will C Holmes" <Will C

 

[Guest]

I suppose the easiest thing to check is if the text evaluated to a result.
Excell could evaluate the cell and if it didn't return an error, then it
should add an equal sign. This would give some false positives, for instance
"3", but "=3" would be the same as "3" in most casses of which I can think.

Another option wuold be to check the cell for specific patterns, for
instance, +, -, /, Excel function names. I realize there are instances in
which these are not meant to be a part of a formula, but most cases they are
meant to be a part of a formula.

In a related subject, It would be great if the autocorrect for spelling
worked in Excel as well. Also, why not red squigly underline spellinging
errors in the forumla bar (or in the sheet).