View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Remove Time from Date

How do I remove the time from a date field ? In Excel, the date is displayed
as follows : 10/30/2007 2:34:24 PM

I need to remove the time from this value. I have tried to format the cell
with the proper date format (ie - mm/dd/yyyy) but the time still remained.

Any help would be GREATLY appreciated.

Thanks!
Rob