excel 2002 convert numbers to mathematical

anon125

Active Member
Joined
Feb 14, 2008
Messages
392
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

tried converting the cell to numbers

thanks all
 
Last edited:

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Remove the hyperlinks
Replace with the $ in the replace with box and the other box blank.
great! how do i do that?
thanks
 
Upvote 0
Hyperlinks - select the column - right click and you will see the remove hyperlinks option.

For the replace see the link below, as well as the $ symbol you will also need to do the same with the - symbol as what you have is a none standard symbol so you will need to copy it from your cell put it in the replace what box and type - in the replace with box.


https://support.office.com/en-us/ar...orksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90
 
Upvote 0
Can't help you there as it does on mine if there are hyperlinks (and nothing if there isn't hyperlinks). You will have to look up how to do it in 2002 as I don't have a copy in front of me. You could try copying the column and pastespecial as values.

Or try running the sub below

Code:
Sub RemoveHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub
 
Upvote 0
P.S. when you do the replaces make sure that match entire cell contents under options is not checked.
 
Upvote 0
went to another computer. both win7 both same version of excel.
those with a minus sign do not give the remove hyperlink option.
the positive numbers do give that option!
BTW i used to live in havant - also in southern england!
thanks
UPDATE they both now remove hyperlink but it is still text. will try the multi option
that only works on the positive ones!!!!
 
Upvote 0
i am going to make a completely new file from scratch and use what you folks have kindly taught me.
thanks
 
Upvote 0
You need to do the 2 replaces as well as the remove hyperlinks (you don't need to select the individual cells, you can do the whole column in one). Btw Havant isn't far away from me :rofl:

If you could post the actual file the I would do it for you but as that isn't an option maybe you could copy/paste the offending column to a different workbook then I could convert it, repost it and then you could paste it back rather than creating a whole new file.
 
Upvote 0

Forum statistics

Threads
1,223,883
Messages
6,175,167
Members
452,615
Latest member
bogeys2birdies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top