leading equal sign assumes formula

B

Bob Carsto

When I set the value of a cell to text that contains a leading equal sign,
excel assumes that is a formula. For example,

ActiveCell.Value = "=SomeText"

How can I prevent this from being treated as a invalid formula?
 
Top