Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get $ signs out of a column in excell
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ... |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Excell: count occurance of letters in a column | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |