Why Excel compares cells?

Compare cells C and S, but Excel they can not compare. Why?
c0abf0fd6045470ab31974360c68437e.png
And if you do convert to number, then the comparison works right. But, like all cells to do this conversion?
de2aebbe75164e7bbda9bc030635a1a5.png
July 2nd 19 at 13:39
1 answer
July 2nd 19 at 13:41
Maybe an extra space? Or format fields, some clever and different.
Or a newline character. try to make cell references in the function of PECKING() - Hans56 commented on July 2nd 19 at 13:44
And if you do convert to number, then the comparison works right. But, like all cells to do this conversion?
de2aebbe75164e7bbda9bc030635a1a5.png - albertha.Ha commented on July 2nd 19 at 13:47

Find more questions by tags Excel