Teams is changing Excel Formulas
Hi, This might be a simple fix for someone but I have an excel worksheet with the formula =XLOOKUP(1,AD37:AD39,AC37:AC39) which works perfectly within excel on the desktop but when I upload it to teams it adds the @ sign =@XLOOKUP(1,AD37:AD39,AC37:AC39) and breaks the formula. Why would it do this? I then have to go into the excel file on teams to delete the @ for it to work.. Any tips/help would be appreciated.
Adding bullets to text in cells in an Excel file in Microsoft Teams
I am working with an Excel file shared in real-time with other people. We are using the file as a scheduler and need to tally how many people we have throughout the day, at any given time (people cancel and others are added). I wanted to add a running count to each column so that we don't have to manually count the people. I thought I could add numbered bullets to each scheduled person and have it be continuous for each column so that a count was constantly autopopulated below each colu. But I do not even have bullets as an option (??), which is incredibly strange and seems like a basic thing to have in Excel. Any ideas? Thank you in advance