Historical Spreadsheet Features


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.
 

My Computer

System One

  • OS
    Win 11
    Computer type
    Laptop
    Manufacturer/Model
    HP

Latest Support Threads

Back
Top Bottom