how do i get $ signs out of a column in excell
 

how do i get $ signs out of a column in excell
 

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
...

how do i get $ signs out of a column in excell
 

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
...

how do i get $ signs out of a column in excell
 

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 :-)
------------------------------*------------------------------*----------------


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

how do i get $ signs out of a column in excell
 

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 & 2003

"Peo Sjoblom" wrote in message
...
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
...