Thread: format date time
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David McRitchie
 
Posts: n/a
Default format date time
Oops serious problem with my reply as MOD(A1,1) would retain only
the time not the date. Dave Peterson 's integer response would be


Reply With QuoteReply With Quote