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...
Pamela_Turner_
Dec 07, 2023Copper Contributor
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"...
ironhandyman1966
Dec 13, 2023Copper Contributor
Read it. Can't do it, LOL. It's not just learning the new symbol, but it's an awkward reach. Ugh!