Prospector
New member
- Local time
- 9:26 PM
- Posts
- 1
- OS
- Win 11
I am researching the history of minus signs allowed in spreadsheet formulas. Nowadays Excel only allows fake minus sign, i.e., hyphen [U+2010, also Alt+45]. When I copy Excel formula text to Word, the fake minus sign hyphens cause unwanted line breaks in the Word text. I asked Microsoft Support how to resolve the problem. They told me to search the pasted text and replace hyphens with nonbreaking hyphens. Duh, Microsoft misses the point that if I then paste the Excel formula text from Word back into Excel, with nonbreaking hyphens instead of plain hyphens, the formula won't work in Excel.
I am older than both Excel and even Lotus 123. I seem to remember that Lotus 123 allowed in formulas five different minus sign variations: hyphen [U+2010, also Alt+45]; true minus sign [U+2212, also Alt+8722]; nonbreaking hyphen [U+2011, also Alt+8209]; en dash [U+2013, also Alt+0150]; and em dash [U+2014, also Alt+0151]. And, I am pretty sure early versions of Excel allowed in formulas two different minus sign variations: hyphen [U+2010, also Alt+45]; and true minus sign [U+2212, also Alt+8722].
If you have the old Lotus 123, or if you have a really old version of Excel, could you post an answer to me whether those programs let you type a formula from the numeric keypad using any minus sign variation besides hyphen [U+2010, also Alt+45]? Please specify a timeframe for the spreadsheet that you check, e.g., early 2000's.
I am older than both Excel and even Lotus 123. I seem to remember that Lotus 123 allowed in formulas five different minus sign variations: hyphen [U+2010, also Alt+45]; true minus sign [U+2212, also Alt+8722]; nonbreaking hyphen [U+2011, also Alt+8209]; en dash [U+2013, also Alt+0150]; and em dash [U+2014, also Alt+0151]. And, I am pretty sure early versions of Excel allowed in formulas two different minus sign variations: hyphen [U+2010, also Alt+45]; and true minus sign [U+2212, also Alt+8722].
If you have the old Lotus 123, or if you have a really old version of Excel, could you post an answer to me whether those programs let you type a formula from the numeric keypad using any minus sign variation besides hyphen [U+2010, also Alt+45]? Please specify a timeframe for the spreadsheet that you check, e.g., early 2000's.
My Computer
System One
-
- OS
- Win 11
- Computer type
- Laptop
- Manufacturer/Model
- HP