all these cells are calculated values - sum (a:z) with the cell characteristics : mm
As someone once wrote in another forum: a picture is worth 1000 words; but an Excel file is worth 1000 pictures.
English (any natural language) is an imprecise tool for describing things.
For example, you write "all these cells are calculated values". But you do not say that AK10 (?; the cell that displays "07:15") contains
a formula that performs the calculation. You might mean that you copy-and-pasted the value.
For another example, you write "with the cell characteristics
: mm"
(sic). Obviously that is not the cell
format, since it displays "07:15".
If you hoover over the cells above you can see that the values are shown as parts of a day (or24 hours); so there is not text included
We cannot hover over the cells, since you posted an image, not even an XL2BB capture.
There does not need to be any text in the cell. But the
type of the cell value might be text, even if the cell has a numeric format like mm:ss .
Looks can be deceiving. And again, the cell format does not matter.
Use formulas of the form
=ISTEXT(AK10) to determine if the
type of the cell value is indeed text.
I still do not understand what causes the problem
And we probably will never understand the problem if we go back and forth posting English descriptions and incomplete images. (Thanks for including the column names. But without the row numbers, we cannot easily talk about individual cells in the image.)
And in this case, I do not believe this forum's XL2BB feature will provide what we need to see. In particular, I do not believe we can distinguish
type text from
type numeric.
Upload an example Excel file (redacted)
that demonstrates the problems to a file-sharing website, and post the download URL in a response here. I like box.net/files; others like dropbox.com.
In any case, test the download URL first, being careful to log out of all websites that share the same login, in order to ensure that anyone else can access the file anonymously.