Forum Discussion
ironhandyman1966
Nov 29, 2023Copper Contributor
@SUM not working
I learned Excel waaaay back. I have always typed in my formulas as @SUM and not =SUM. For some reason the @ version is not currently working. Did Microsoft phase this out? I can't find anything o...
TriState_Senior
Jan 27, 2024Copper Contributor
The Lotus Translation feature, which allowed the "@" symbol to function as the "=" sign in Excel, has been deprecated, with the default setting now disabling it. This modification may elicit a sense of irony, as an individual within the Microsoft organization may have sought to inject humor into the situation.
The process for reactivating the Lotus Translation feature is outlined in the provided reference. However, it has a notable drawback; it does not persistently remain enabled, as indicated in the accompanying text.
https://answers.microsoft.com/en-us/msoffice/forum/all/cant-use-in-excel-2021-formulas-anymore/bc2ab73e-d606-4d37-bd9e-830177e13005
Notably, some users, particularly those with a long-standing history of utilizing Lotus 1-2-3 predating the emergence of Excel, have grown accustomed to employing the "@" symbol for formula entry. Consequently, the enforced transition to the "=" sign can be seen as a significant departure from a practice ingrained over four decades. The abrupt shift imposed by Microsoft, altering a familiar convention, may understandably be met with frustration and bewilderment among users.
The abrupt shift imposed by Microsoft, altering a familiar convention, may understandably be met with frustration and bewilderment among users. Some may view this change as indicative of Microsoft's self-centered and egotistical approach, seemingly disregarding the long-standing user preferences and established industry conventions in favor of imposing their own standards. This departure from accommodating user habits underscores a broader trend in the tech industry, where software giants occasionally prioritize their corporate agendas over the user experience and preserving legacy practices.
The process for reactivating the Lotus Translation feature is outlined in the provided reference. However, it has a notable drawback; it does not persistently remain enabled, as indicated in the accompanying text.
https://answers.microsoft.com/en-us/msoffice/forum/all/cant-use-in-excel-2021-formulas-anymore/bc2ab73e-d606-4d37-bd9e-830177e13005
Notably, some users, particularly those with a long-standing history of utilizing Lotus 1-2-3 predating the emergence of Excel, have grown accustomed to employing the "@" symbol for formula entry. Consequently, the enforced transition to the "=" sign can be seen as a significant departure from a practice ingrained over four decades. The abrupt shift imposed by Microsoft, altering a familiar convention, may understandably be met with frustration and bewilderment among users.
The abrupt shift imposed by Microsoft, altering a familiar convention, may understandably be met with frustration and bewilderment among users. Some may view this change as indicative of Microsoft's self-centered and egotistical approach, seemingly disregarding the long-standing user preferences and established industry conventions in favor of imposing their own standards. This departure from accommodating user habits underscores a broader trend in the tech industry, where software giants occasionally prioritize their corporate agendas over the user experience and preserving legacy practices.