Thread: Remove time from date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Little Penny[_3_] Little Penny[_3_] is offline
external usenet poster
  
Posts: 48
Default Remove time from date
Is there a macro that can remove the time from the date. I tried
formating the cell and it remove time from the cell. However if you
select the cell the time remains.

3/20/2009 8:10:40 PM

Reply With QuoteReply With Quote