I’m crap at Excel.However, I am trying to analyse our expenses. The adviser uses a platform with everything listed and you can upload it into an excel spread sheets.
I am using office for mac and am on mojave.
I’ve saved it to xlsx.
Back in the day I used to be able to just highlight rows , click on autosum and hey presto.!Now it gives me an are you trying to create a formula? pop up box.So I thought maybe it is the dollar signs so I went to numbers and nominated general which was supposed to do the trick. Nope. A mate suggested thecomma button below it. Nada.