Unless the OP means absolute vs relative references, then a macro like this

Sub AbstoRel()
Dim Cell As Range
For Each Cell In Selection
Cell.Formula = Application.ConvertFormula(Cell.Formula, xlA1, xlA1,
xlRelative)
Next
End Sub

--
Regards,

Peo Sjoblom

(No private emails please)


"Paul B" wrote in message
...
niecey, try format, cells, symbol, none

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"niecey merc" <niecey wrote in message
...