View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick[_24_] Rick[_24_] is offline
external usenet poster
 
Posts: 1
Default Excel Macro text swap

I need to change the date format in a column from 2004/2/30 to
2/30/2004. There are 1,500 dates to change, in the column, and some
are already in the correct format. Using the Date format for the
column properties does not correct this problem. I tried to make a
macro, which works, but it includes the original text, so can only be
used once. Any suggestions on this are appreciated.