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