Solved: userform label format

[av8tordude]

In cell G2 is a time formated value (i.e. 23:24). I'm not sure why this code is not displaying this value in my userform label. Currently the label displays 0.974999. Can someone assist. thanks

[vba]
TDay.Caption = Range("AG2")

[/vba]

[av8tordude]

disregard...i figured it out

TDay.Caption = format(Range("AG2") ,"hh:mm")

[IBihy]

Hello,

methinks, you should mark this thread as solved.

Isabella

[av8tordude]

How do I get the label to display 26:52 instead of 02:52.

[VBA]TDay = Format(Range("AG2"), "HH:MM")[/VBA]

[Tinbendr]

try "[h]:mm"

David