excel 2002 convert numbers to mathematical

[anon125]

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

 

[anon125]

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] >

 

[Joe4]

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.

 

[anon125]

no there are no ? in the spreadsheet.
thanks

[/IMG]

 

[anon125]

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

 

[MARK858]

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?

 

[anon125]

Are you saying that post 11 is the result you get when you carry out the instructions above by Rick?

yes, that is what was in the immediate window.

we just retype the numbers but there is a lot more!
thanks

 

[MARK858]

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

 

[anon125]

we could just retype the numbers but there is a lot more!
is what i should have written!
thanks

 

[MARK858]

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.

 

[anon125]

i would rather not post the file just yet
thanks