Thread: Date Formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fluffy fluffy is offline
external usenet poster
 
Posts: 18
Default Date Formatting

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