|
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!! |
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!! |
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!! |
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!! |
| All times are GMT +1. The time now is 03:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com