View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jim jim is offline
external usenet poster
 
Posts: 2
Default macro to rearrange numbers in cell?

We have general office workers in our school district who use an
antiquated student information system to download roster information in
text format for import into Excel. A user recently asked me if there is
a way to globally change the outputted date format 20011028 to 10282001
after it has been imported. I'm thinking a macro would do it. Any ideas
would be greatly appreciated.

Thanks,

-Jim Epler
Grossmont Union High School District
El Cajon, CA
http://edtech.guhsd.net/