Forum Discussion
@SUM not working
ironhandyman1966 Am perhaps not old enough (born 1962) and worked with Excel for the past 38 years. Can't remember it was ever @ that designated a formula. Always used =. But perhaps my memory serves me wrong.
I converted from Lotus 123 to Excel around 1998 and continued using the legacy @ symbol as the beginning to all formulas, despite knowing that Excel instructions say you should use the = sign. I just discovered that @ no longer works and this old dog will have to learn a new trick. ugh.... sounds like a simple fix, but probably like you, I type in formulas very quickly and without thinking and I fear this will be a real challenge (albeit a first world one 🙂 A quick google search indicates that Microsoft has adopted the @ sign to enable some "implicit intersection operator", so that's why they probably had to disable the legacy use of the symbol. I guess maybe we need to reread "Who Moved my Cheese"...
- ironhandyman1966Dec 13, 2023Copper ContributorRead it. Can't do it, LOL. It's not just learning the new symbol, but it's an awkward reach. Ugh!