I'm making a workbook for my credit card statements so I can track expenses,
when I copy and paste from my Credit Cards online site the column that shows
the dollar amount pastes onto my worksheet as a hyperlink. How can I change
the whole column to just a dollae figure?

Thanks

a simple way to remove all hyperlinks in a sheet
insert a module and paste this sub

Sub delHyperlinks()

ActiveSheet.Hyperlinks.Delete

End Sub



"Just Me" wrote:

I'm making a workbook for my credit card statements so I can track expenses,
when I copy and paste from my Credit Cards online site the column that shows
the dollar amount pastes onto my worksheet as a hyperlink. How can I change
the whole column to just a dollae figure?

Thanks