View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default Changing Imported Date Formats

If A1 contains the date/time, then in another cell enter =INT(A1).
--
Gary''s Student


"Craig Lloyd" wrote:


Gary - How do i use he INT function?


--
Craig Lloyd
------------------------------------------------------------------------
Craig Lloyd's Profile: http://www.excelforum.com/member.php...o&userid=29769
View this thread: http://www.excelforum.com/showthread...hreadid=494842