How to remove link from number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Just Me - 07 Nov 2006 05:35 GMT

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

Reply to this Message

Dave Peterson - 07 Nov 2006 13:03 GMT

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.

> 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

Signature

Dave Peterson

Reply to this Message

Bernard Liengme - 07 Nov 2006 13:10 GMT

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

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>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

Reply to this Message

Rate this thread: