May 31 2022 06:16 PM
Often, that means that the type of the cell value is text, despite appearances.
The cell format does not matter. And looks can be deceiving.
Use formulas of the form =ISTEXT(A1) to determine if the type of the cell value is text.