Thread: Converting "Date and Time" to just DATE?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert Blass Robert Blass is offline
external usenet poster
  
Posts: 35
Default Converting "Date and Time" to just DATE?
I have a large number of cells with date and time like this, "Jan 12,
2001 5:55 pm"
I want to truncate the time in the cell and only make it display the
date.

Can someone help me?
Reply With QuoteReply With Quote