software

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 amp; 2003

quot;niecey mercquot; lt;niecey gt; wrote in message
...
gt;
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)quot;Paul Bquot; gt; wrote in message
...
gt; niecey, try format, cells, symbol, none
gt;
gt; --
gt; Paul B
gt; Always backup your data before trying something new
gt; Please post any response to the newsgroups so others can benefit from it
gt; Feedback on answers is always appreciated!
gt; Using Excel 2002 amp; 2003
gt;
gt; quot;niecey mercquot; lt;niecey gt; wrote in message
gt; ...
gt;gt;
gt;
gt;A bit more detail would help us give you specific answers

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------quot;niecey mercquot; lt;niecey gt; wrote in message
...
gt;
Could be, but you could also do a replace $ with blank for that and not have
to use a macro

--
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 amp; 2003

quot;Peo Sjoblomquot; gt; wrote in message
...
gt; Unless the OP means absolute vs relative references, then a macro like
this
gt;
gt; Sub AbstoRel()
gt; Dim Cell As Range
gt; For Each Cell In Selection
gt; Cell.Formula = Application.ConvertFormula(Cell.Formula, xlA1, xlA1,
gt; xlRelative)
gt; Next
gt; End Sub
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; (No private emails please)
gt;
gt;
gt; quot;Paul Bquot; gt; wrote in message
gt; ...
gt; gt; niecey, try format, cells, symbol, none
gt; gt;
gt; gt; --
gt; gt; Paul B
gt; gt; Always backup your data before trying something new
gt; gt; Please post any response to the newsgroups so others can benefit from it
gt; gt; Feedback on answers is always appreciated!
gt; gt; Using Excel 2002 amp; 2003
gt; gt;
gt; gt; quot;niecey mercquot; lt;niecey gt; wrote in message
gt; gt; ...
gt; gt;gt;
gt; gt;
gt; gt;
gt;