How to remove link from number

J

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
 
D

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

Bernard Liengme

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