Dec 09 2021 12:53 PM
When I download a document, the cells are not calculating. I have made sure that the format is number.
Is there thing else I can check?
Dec 09 2021 01:04 PM
Dec 09 2021 01:05 PM
Please check if in Formula tab Calculation Option is set on Automatic and Show Formulas is OFF
Dec 09 2021 01:15 PM - edited Dec 09 2021 01:17 PM
@iphill8181 wrote: ``When I download a document, the cells are not calculating. ``
What do you mean by "a document"? Exactly what type of file is it? (Note: a CSV file is __not__ an "Excel" file.)
What do you mean by "not calculating"? Exactly what do you see in the cells (not the Formula Bar)? For example, the formulas themselves? Previous non-zero values? Zeros? Excel errors like #VALUE?
@iphill8181 wrote: ``I have made sure that the format is number.``
The __format__ of a cell does not matter. The __type__ of cell value does. Looks can be deceiving. Use formulas like =ISNUMBER(A1) to determine if the cell value is indeed numeric.
If this and other suggestions do not point you to the problem, attach an Excel file (not an image or CSV file) that demonstrates the problem.
Dec 09 2021 01:15 PM
Dec 15 2021 05:40 AM
Dec 15 2021 11:07 AM