Format problem in displayed userform

[redspanna]

Hi all,

In sheet 'DATA' cells B12 and I12 are the source data
these are copy/pasted into cells B2 and I12 of 'RESULTS' sheet
all of these cells are formatted as 'Custom hh:mm' however when I place these values into my userform they are with no format ie 0.42342423154238

Any ideas as to why??

many thanks

 

[redspanna]

I manged to format the entry in my oginal code to help format the userform,

frmOldJob.Label22.Caption = Application.WorksheetFunction.Text((Range("I2")), "hh:mm")

and this works fine