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

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
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,487
Messages
6,113,941
Members
448,534
Latest member
benefuexx

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