excel 2002 convert numbers to mathematical

anon125

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

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,148
Office Version
365
Platform
Windows
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

Active Member
Joined
Feb 14, 2008
Messages
343
no there are no ? in the spreadsheet.
thanks
[/IMG]
 
Last edited:

anon125

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

Well-known Member
Joined
Nov 12, 2010
Messages
11,329
Office Version
365, 2010
Platform
Windows, Mobile
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

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

Well-known Member
Joined
Nov 12, 2010
Messages
11,329
Office Version
365, 2010
Platform
Windows, Mobile
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:
 

anon125

Active Member
Joined
Feb 14, 2008
Messages
343
we could just retype the numbers but there is a lot more!
is what i should have written!
thanks
 

MARK858

Well-known Member
Joined
Nov 12, 2010
Messages
11,329
Office Version
365, 2010
Platform
Windows, Mobile
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.
 

Forum statistics

Threads
1,078,253
Messages
5,339,105
Members
399,278
Latest member
randomNumberGenerator2211

Some videos you may like

This Week's Hot Topics

Top