add = sign before number

[annadinesh]

dear sir,

sometime we put the following in a cell forgetting using = sign and gets an error or no result

25+35+66+66

i want a vba that automatically add = sign before the numbers

like =25+35+66+66

so that its show the added value


thank you

 

[gallen]

This works for all new cells. Do you need one to check all current cells too?

Caution though. whenever you use a "+" in a cell it will add an = to the start. If there are instances where you won't want that then it may need a re-think

Private Sub Worksheet_Change(ByVal Target As Range)
    If InStr(1, Target, "+") > 0 And Left(Target, 1) <> "=" Then
        Target = "=" & Target
    End If
End Sub

 

[annadinesh]

A big thanks to you,

my problem solved


thanks again