Timeline for Convert a text string with a leading dash to a negative number
Current License: CC BY-SA 4.0
7 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Aug 23, 2018 at 10:51 | comment | added | Seamus | I'll try this as soon as I am able, and let you know the result. | |
Aug 23, 2018 at 5:21 | history | edited | Akina | CC BY-SA 4.0 |
added 1124 characters in body
|
Aug 23, 2018 at 5:14 | comment | added | Akina | @Seamus Debugging added. Try. Did I get the substitution wrong in your macro? No. But I am afraid the symbols were "broken" when copypasted... Try to check them - look for a hyphen char code in source data. | |
Aug 23, 2018 at 5:13 | history | edited | Akina | CC BY-SA 4.0 |
added 1124 characters in body
|
Aug 22, 2018 at 22:20 | comment | added | Seamus | to continue: Am I missing something? Did I get the substitution wrong in your macro? | |
Aug 22, 2018 at 22:19 | comment | added | Seamus |
Your macro seems to convert a "negative text number" to a real number, but I cannot get it to make it negative real number. I replaced <dash><hyphen> in your macro with two characters: -– . The first character is the hyphen/minus symbol from my MacBook keyboard, and the second is an the character which was in the data I pasted into Excel. I think it is an "em dash"? And yes, I did call the leading character a "hyphen" in my question, but I learned during testing another answer here that it's not a hyphen.
|
|
Aug 22, 2018 at 5:31 | history | answered | Akina | CC BY-SA 4.0 |