Forum Discussion
Errors in spreadsheet
My dates are 5 numbers and cannot change them. My dollar amounts will not add. The sum formula does nothing. How can you tell if a spreadsheet is locked?? It almost acts like it is .. I have sw...
In order of the questions,
try right clicking on the values and pressing number format. It may give you options to modify.
Try the same thing with your dollar amounts, that may help the sum formula work more effectively
If a sheet is locked, I'm pretty sure a "lock" icon is shown next to the name of the sheet.
Are you using Excel online, or a version of 365 Excel?