View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anthony Anthony is offline
external usenet poster
 
Posts: 275
Default Format problem in displayed userform

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