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

Perfect.

"Gary''s Student" wrote:

Format Cells... Number Custom
m/dd/yyyy
--
Gary's Student
gsnu200707


"leonardoromero" wrote:

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!!