View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
iris iris is offline
external usenet poster
 
Posts: 12
Default Need macro to change date from yyyymmdd format to mm/dd/yyyy forma

I received some data with the dates in a yyyymmdd format. Although I can go
in and change this by splitting the data up with the text to column option,
then concatenate the rows with a "/" in between them, I was wondering if
anyone has put together a macro to do this a bit faster than it takes to go
through all of these other steps.

Thanks,
--
Acknowledge and Move on.