I have a program that exports daily data to excel. However it exports dates
in the following format: 15 Feb, 2011

In order to sort columns properly I need to change the dates to reflect:
02/15/11 Is there a way to do this.

I cannot change it by simply formatting the cell to the date format

Do a find & replace on the data to remove the comma.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"fluffy" wrote:

I have a program that exports daily data to excel. However it exports dates
in the following format: 15 Feb, 2011

In order to sort columns properly I need to change the dates to reflect:
02/15/11 Is there a way to do this.

I cannot change it by simply formatting the cell to the date format

DataText to ColumnNextNextColumn data formatDateDMY worked for me
with your example data.


Gord Dibben MS Excel MVP

On Thu, 11 Feb 2010 09:47:03 -0800, fluffy
wrote:

I have a program that exports daily data to excel. However it exports dates
in the following format: 15 Feb, 2011

In order to sort columns properly I need to change the dates to reflect:
02/15/11 Is there a way to do this.

I cannot change it by simply formatting the cell to the date format