A cell, containing time, is shown as a numeric value

[lshilin]

Hi,

One of the columns in the table I use for a chart building is in time format (I even see it when is standing with coursor on a cell from the column: it looks like 20:20:06 in the cell and 8:20:06 PM in the formula bar).

The problem begins when I try to use these cells for data validation, i.e. to check that it is data that look like 20:20:06 and not like 20:20.06 or 30:06. From some reason in my macros I see in debug mode that the value of these cells turns to be a numeric value like 0.18765.

Why does it happen? How to "outflang" this problem?

Here is the code I tried to use for validation:

If InStr(Cells(RowNum, 1), ":") = 0 Or Len(Cells(RowNum, 1)) < 5_
Or InStrRev(Cells(RowNum, 1), ":") <> Len(Cells(RowNum, 1)) - 2 Then
Rows(RowNum).Delete Shift:=xlUp 'Delete the rows in which the first column is not in time format
End If


Please, help me
Many thanks