Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 31

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

  1. #21
    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


  2. #22
    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

    Remove the hyperlinks then do a Replace with the $ in the replace with box and the other box blank.

    https://app.box.com/s/8e8ca9jhuvwkemtn4vyof7xaggs45c3t

    then format your cells as desired.
    Last edited by MARK858; Oct 17th, 2019 at 07:50 PM.
    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

  3. #23
    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

    Remove the hyperlinks
    Replace with the $ in the replace with box and the other box blank.
    great! how do i do that?
    thanks

  4. #24
    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

    Hyperlinks - select the column - right click and you will see the remove hyperlinks option.

    For the replace see the link below, as well as the $ symbol you will also need to do the same with the - symbol as what you have is a none standard symbol so you will need to copy it from your cell put it in the replace what box and type - in the replace with box.


    https://support.office.com/en-us/art...f-fdb42f892e90
    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

  5. #25
    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

    right click does not have the remove hyperlinks option.
    it has one for hyperlinks.
    thanks

  6. #26
    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

    Can't help you there as it does on mine if there are hyperlinks (and nothing if there isn't hyperlinks). You will have to look up how to do it in 2002 as I don't have a copy in front of me. You could try copying the column and pastespecial as values.

    Or try running the sub below

    Code:
    Sub RemoveHyperlinks()
    ActiveSheet.Hyperlinks.Delete
    End Sub
    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

  7. #27
    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

    P.S. when you do the replaces make sure that match entire cell contents under options is not checked.
    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. #28
    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

    went to another computer. both win7 both same version of excel.
    those with a minus sign do not give the remove hyperlink option.
    the positive numbers do give that option!
    BTW i used to live in havant - also in southern england!
    thanks
    UPDATE they both now remove hyperlink but it is still text. will try the multi option
    that only works on the positive ones!!!!

  9. #29
    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 am going to make a completely new file from scratch and use what you folks have kindly taught me.
    thanks

  10. #30
    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

    You need to do the 2 replaces as well as the remove hyperlinks (you don't need to select the individual cells, you can do the whole column in one). Btw Havant isn't far away from me

    If you could post the actual file the I would do it for you but as that isn't an option maybe you could copy/paste the offending column to a different workbook then I could convert it, repost it and then you could paste it back rather than creating a whole new file.
    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

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
  •