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

https://www.engram9.info/excel-2002-vba-xml-asp/using-the-immediate-window.html

Don't miss the previous post by Joe4
compile error
expected :expression


this is what i get with the vba thingy in excel 2002
thanks
[auto_open] <
[SetupFunctionIDs] <
[SetupFunctionIDs] >
[PickPlatform] <
[PickPlatform] >
[VerifyOpen] <
[VerifyOpen] >

AMOUNT
?$2.99
$3.99
$2.99
$2.99
?$2.99
?$3.99
$35.00
?$35.00
$2.08
$3.33
?$2.08
?$2.08
?$2.08
?$2.08
?$2.08
$5.00
?$0.99
?$3.99
?$2.08
?$5.00
?$5.00
?$25.48
?$2.08
?$2.08
?$0.99
?$2.08
?$25.16

[RegisterFunctionIDs] <
[RegisterFunctionIDs] >
[auto_open] >
 
Last edited:
Upvote 0

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Are there really question marks and dollar signs in your text data?
If so, then you will need to remove those to make them actual numbers.
A simple Find/Replace can do that, or it can be done via formulas or VBA.
 
Upvote 0
no there are no ? in the spreadsheet.
thanks
61hArKSl.png
[/IMG]
 
Last edited:
Upvote 0
also if i click on a number it is still an internet link and tries to go to the bank site.
how do i stop that?
tried copy and paste special- then must have tried the wrong option!
thanks
 
Upvote 0
1) Select the column with your "numbers" in it.

2) Go into the VBA editor (ALT+F11) and type this into the Immediate Window and then press the Enter Key...

Selection.Replace Chr(160), "", xlPart, , , , False, False

Are you saying that post 11 is the result you get when you carry out the instructions above by Rick?
 
Upvote 0
What do you mean "we retype the numbers"? you select the numbers in the spreadsheet, paste the one line of code Rick posted in the Immediate window and press Enter.

There shouldn't be any retyping of numbers involved :confused:
 
Upvote 0
we could just retype the numbers but there is a lot more!
is what i should have written!
thanks
 
Upvote 0
I think we are probably back to what joeu2004 wrote back in post number 4.

It would help (us) if you uploaded an example Excel file to a file-sharing website and posted the download URL here
.

If you can upload your file to www.box.com (the personal version is free but a bit hard to navigate to these days) or www.dropbox.com, mark the file for sharing and post the link it produces in the thread. Make sure you sanitize any sensitive data (all we are really interested in is the numbers column) before uploading.
 
Upvote 0

Forum statistics

Threads
1,213,526
Messages
6,114,136
Members
448,551
Latest member
Sienna de Souza

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