It's probably because the format of your column is set to text, so it can't calculate the sum. Try changing the format of the cells to standard. If you don't see any change, it's because you need to refresh your cells by selecting each one and pressing "F2" then Enter on each of them.
Are you able to enter your formula? The formula remains in formula form? The result is not updated? Which cell are you unable to change the format of? What is your formula?
Best regards,
jp
Hello, When I try to sum it, it shows 0. When I want to apply a cell format style, it does nothing as if I had a text style or something that locks the content of my cell. I tried currency, accounting styles... no difference. Initially, I imported this data in CSV format from phpMyAdmin. Thanks for the help
jp
>
jp
Yes, I can enter my formula which is not very complicated: Sum of the start of the column and the end of the column. No, the formula does not remain in formula form, showing 0. I cannot modify a single cell in this table and in fact, this is not specific to this file, so I think it has to do with Excel's options. Thank you.
we were stuck on the same issue and thanks to you, we're making progress!
Where can I find the "Convert"…?