How to remove link from number

[Just Me]

I copy and paste my credit card info into a spreadsheet so I can track my
expenses, when I paste the data in the dollar amounts show up as links. How
can I remove the link and just have them dollar amounts

thanks in advance

 

[Dave Peterson]

Can you paste each value directly into the formulabar?

Or you could remove the hyperlinks after you paste.

Select the range to fix
Hit alt-f11 (to get to the VBE)
hit ctrl-g (to see the immediate window)
type this and hit enter:
selection.hyperlinks.delete

Then back to excel to check it out.

 

[Bernard Liengme]

C opy and Paste from where?
Try Paste Special | values to get just numbers (if I understand the
problem!)
best wishes