Here is the VBA Code to Add Dollar Sign “$$” in Excel Sheet by One Click with VBA Code:
Sub InsertDollarSigns()
Dim cellRange As Range
For Each cellRange In ActiveSheet.Cells.SpecialCells(xlCellTypeFormulas)
cellRange.Formula = Application.ConvertFormula(cellRange.Formula, xlA1, xlA1, True)
Next
End Sub
Download VBA Code Here