Formula without $ string function

[sdsurzh]

Hi,


I have some formula without String ($) now i want replace the formula with string function.


Suppose A1 =C1+D1 i want A1 = $C$1+$D$1


Thanks,

Suresh Kumar S

 

[oldchippy]

Hi,


Select C1+D1 in the formula bar and press F4 key

 

[shrivallabha]

That is not 'String' converter as in VBA but it rather means Absolute Reference.


Read here:

http://www.cpearson.com/excel/relative.aspx

 

[sdsurzh]

Thanks Oldchippy & Shrivallabha is it possible to add $ (Absolute Reference) with the help of vba.