Jan 01 2019 11:24 AM
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 switched from locked back and forth and nothing happens.
I sure liked the original excel and the current one so much..
Bill Lambing
Greenwood IN
Recovering from a stroke..
Jan 01 2019 12:55 PM
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?
Jan 01 2019 01:12 PM
Jan 01 2019 01:23 PM
I've never encountered something like that. I wish you the best in finding a solution.
Jan 01 2019 04:40 PM
Jan 01 2019 04:42 PM
Jan 07 2019 06:00 AM
Hi Bill,
If you haven't sorted this yet try this,
First under Excel Preferences check what Calculation options are set, see screenshot. Secondly on the review Tab there should be "Protect Sheet" and "Protect Workbook" options, if they are entitled Protect then the sheet is unprotected and Unprotect means its protected.
For your dates check that the cell isn't formatted as text.
Hope this helps,
Rich
Jan 07 2019 10:43 AM
Rich ... nothing worked .. the calls are not text. Don't know what the answer is, but this version of excel is pretty close to worthless for me. if I evaluate the cells I get a correct answer...?????
Jan 07 2019 10:45 AM