Date Formatting

  • Thread starter Thread starter fluffy
  • Start date Start date
F

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
 
Data>Text to Column>Next>Next>Column data format>Date>DMY worked for me
with your example data.


Gord Dibben MS Excel MVP
 
Back
Top