Thread: Delete Date data macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KAnoe KAnoe is offline
external usenet poster
  
Posts: 20
Default Delete Date data macro
I get an excel sheet that has the date format like this:

8/9/04 1:25:43 PM EDT

How whould I set up a macro that would delet all that data after the year
number? can this be done?

THnanks
Reply With QuoteReply With Quote