This Macro removed all the dollar signs for me:

Sub Trial()
For Each cell In Selection
cell.Formula = Application.Substitute(cell.Formula, "$", "")
Next cell

End Sub

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"CC" wrote in message
...
I need help with this same thing and noticed no one answered. Did you ever
resolve this issue?




"billbrandi" wrote:

Is there a quick way to convert fixed cell references ($row$column) to
eliminate the $ without editing the formula and deleting the $ one
keystroke
at a time? Sure would save me a lot of time.

Thanks
Bill Falzone