LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP!! ARRANGE DATA MONTHWISELY IN ROWS sajay Excel Worksheet Functions 9 November 25th 06 01:50 PM
How do i arrange the data to create a pivot table? mr1176 Excel Discussion (Misc queries) 1 January 29th 06 05:30 AM
re-arrange data in date order ereurts Excel Worksheet Functions 1 December 28th 05 03:25 AM
how to split data into columns and arrange the resulting data jack Excel Discussion (Misc queries) 1 November 11th 05 11:20 PM
arrange data by criteria Jeff New Users to Excel 4 May 24th 05 07:57 PM


All times are GMT +1. The time now is 05:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"