Page 2 of 4 FirstFirst 1234 LastLast
Results 11 to 20 of 31

Thread: excel 2002 convert numbers to mathematical
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular
    Join Date
    Feb 2008
    Posts
    329
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: excel 2002 convert numbers to mathematical

    Quote Originally Posted by MARK858 View Post
    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-...te-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 by anon125; Oct 17th, 2019 at 05:26 PM.

  2. #12
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    51,032
    Post Thanks / Like
    Mentioned
    57 Post(s)
    Tagged
    11 Thread(s)

    Default Re: excel 2002 convert numbers to mathematical

    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.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #13
    Board Regular
    Join Date
    Feb 2008
    Posts
    329
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: excel 2002 convert numbers to mathematical

    no there are no ? in the spreadsheet.
    thanks[IMG][/IMG]
    Last edited by anon125; Oct 17th, 2019 at 05:35 PM.

  4. #14
    Board Regular
    Join Date
    Feb 2008
    Posts
    329
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: excel 2002 convert numbers to mathematical

    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

  5. #15
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    11,230
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    2 Thread(s)

    Default Re: excel 2002 convert numbers to mathematical

    Quote Originally Posted by Rick Rothstein View Post
    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?
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

  6. #16
    Board Regular
    Join Date
    Feb 2008
    Posts
    329
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: excel 2002 convert numbers to mathematical

    Quote Originally Posted by MARK858 View Post
    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

  7. #17
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    11,230
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    2 Thread(s)

    Default Re: excel 2002 convert numbers to mathematical

    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
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

  8. #18
    Board Regular
    Join Date
    Feb 2008
    Posts
    329
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: excel 2002 convert numbers to mathematical

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

  9. #19
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    11,230
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    2 Thread(s)

    Default Re: excel 2002 convert numbers to mathematical

    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.
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

  10. #20
    Board Regular
    Join Date
    Feb 2008
    Posts
    329
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: excel 2002 convert numbers to mathematical

    i would rather not post the file just yet
    thanks

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •