| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
re-arrange cell data
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!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
re-arrange cell data
If your dates are stored as dates, but formatted as yyyy/mm/dd, then you
should be able merely to format the cells as dd/mm/yyyy. If, however, your cells are text and not dates, the easy option is Data/ Text to Columns/ Delimited/ out to the last stage, at which point select Column Data Format as Date: YMD. When you've got your data converted to a date in Excel terms, you can then format the cells appropriately. -- David Biddulph "leonardoromero" wrote in message ... 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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP!! ARRANGE DATA MONTHWISELY IN ROWS | Excel Worksheet Functions | |||
| How do i arrange the data to create a pivot table? | Excel Discussion (Misc queries) | |||
| re-arrange data in date order | Excel Worksheet Functions | |||
| how to split data into columns and arrange the resulting data | Excel Discussion (Misc queries) | |||
| arrange data by criteria | New Users to Excel | |||
Linear Mode
