don’t want to automatically add “@” symbol in excel formula

I am adding a formula using VBA in a excel cell and excel automatically adding a “@” symbol after the “=” sign.

this is the vba code.

It is putting the whole string as formula but also adds the @ symbol and the formula didn’t expand.

But if I manually remove the @ then the formula works as expencted.

Sorry for not adding screenshots using basic example.

How to tackle this problem. How to remove this “@” symbol using vba ??? And what is the function of this symbol?