Results 1 to 4 of 4

Thread: Ok... what's with this minus sign?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Sep 2018
    Posts
    132
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Ok... what's with this minus sign?

    So I have a data set that I import off of a website. The positive numbers look good. But this minus sign is double the size of a regular negative.

    Website value: –0.13%
    Regular value: -0.13%

    I've tried to do find and replace, but that doesn't work. The problem is, I use the copy / paste special (multiply), and it doesn't work on the website value.

    How does one approach this situation? I even checked if there's a special locale or something along those lines that could be causing this, but the cell looks relatively generic, aside from the size of the minus sign.
    Last edited by srosk; Mar 11th, 2019 at 12:55 PM.

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,362
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Ok... what's with this minus sign?

    It's probably an En dash use search/replace & search for Alt 0150
    You need to hold down the Alt key whilst you type the numbers & you must you the number keypad, not the numbers above the main keyboard
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    Board Regular
    Join Date
    Sep 2018
    Posts
    132
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Ok... what's with this minus sign?

    Quote Originally Posted by Fluff View Post
    It's probably an En dash use search/replace & search for Alt 0150
    You need to hold down the Alt key whilst you type the numbers & you must you the number keypad, not the numbers above the main keyboard
    I had no idea about these other types of dashes. Thanks so much!! With your help and updating xlwhole to xlpart on the find/replace code, this is now working correctly. Thank you again for your help!

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,362
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Ok... what's with this minus sign?

    You're welcome & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

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
  •