How to type text with "$" in Excel

excel
excel-formula

#1

Hi,

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


#2

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


#3

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.


#4

Great :grinning: