Dato format - time info not getting saved in variable

Do you really need to fix it?
If it is a genuine date

    Dim b As Date
    b = Range("N" & t).Value
    MsgBox b
    MsgBox Format$(b, Range("N" & t).NumberFormat)

Or if you need it how it looks regardless of the data type then use .Text property

Dim b As String
b = Range("N" & t).Text

Hi.

Thanks for your reply.

Yes, I need to fix it since I do a date comparison so 00:00 is bigger than f.ex 22.00 and when its nothing it assumes that its bigger.

I also see now that the value that's actually in the cell also have seconds. So when it saves the other variables it comes with milliseconds.

Your Range("N" & t).Text seems to work but I adjusted your Format idea so it also includes the seconds. Just in case and then it gets 100% correct. (I think)

b = Format(Range("N" & t).Value, "dd.mm.yyyy hh:mm:ss")

Then why not convert it to a numeric value to compare?
e.g

msgbox cdbl(Range("N" & t).Value)