Date Formatting

[fluffy]

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

 

[Luke M]

Do a find & replace on the data to remove the comma.

 

[Gord Dibben]

Data>Text to Column>Next>Next>Column data format>Date>DMY worked for me
with your example data.


Gord Dibben MS Excel MVP