View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
leonardoromero leonardoromero is offline
external usenet poster
 
Posts: 4
Default re-arrange cell data

I have the following data......
2007/01/23
2007/01/25
2007/01/25
2007/01/25
2007/01/25
2007/01/26
2007/01/26

.....and I need to re-arrange the data so that is looks like this.

01/23/2007
01/25/2007
01/25/2007
01/25/2007
01/25/2007
01/26/2007
01/26/2007

Any ideas?
Thanks!!