i copied numbers from an online account.
pasted them into excel 2002.
how do i convert the numbers to numbers i can multiply etc?
i tried putting a 1 into a cell then copying and paste special multiply
Thanks for trying Rick, but when i press Alt+F11 i just get a grey screen in the VBA editor. nowhere to type!
so i added a module and typed it there but to no avail.
what did i miss?
PS the numbers were links at first
I think you missed the Immediate Window part, if you can't see it in the VBE click the View icon then click Immediate Window, it normally appears at the bottom of the window where you type your code. Please note that you might need to drag the top of it to expand it.
See the link below to see how it appears.