View Single Post
  #1   Report Post  
jennie
 
Posts: n/a
Default Remove Time Element of a Date


Hi,

I have a list of cells with a date and time value - I want a formula
that will remove the time element and just leave a date.

Thanks
Jennie


--
jennie
------------------------------------------------------------------------
jennie's Profile: http://www.excelforum.com/member.php...fo&userid=6706
View this thread: http://www.excelforum.com/showthread...hreadid=385529