How to check a value is not treated as text by Excel

[hsandeep]

I have punched a date time value in cell C1. How to check that Excel should not be treating it as a text. It should treat it as a value only.

 

[Momentman]

Maybe a quick check is to look at the alignment in the cell. If it is aligned left, its treated as text, if right, treated as number

 

[hsandeep]

No. That didn't work for checking. I made the cell aligned right. Even then Excel is treating it as a text.

 

[Momentman]

You could use the ISNUMBER function maybe, =ISNUMBER(A1) and see if it returns TRUE or FALSE