How to type text with "$" in Excel




Trying to enter formulas where i have fix the cell, in the type text, when i am entering with $ ( which is used to fix the cell, getting error.

Kindly suggest.



@prabhu_venkat do you use Excel actions (set cell name) or open the file and then type in the text using keystrokes?


Well, i have to keep excel open and perform this action.

Any ways, I got the solution on my own…i have defined my excel formula as variable and input the formula as text by calling from variable.


Great :grinning: