View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
frogstyle frogstyle is offline
external usenet poster
 
Posts: 1
Default Separating dates from one column to Month, Date, Year columns

I'm looking for a way to take a list of dates that are being cut and pasted
from an Access Database into excel and separate it so I can sort by Month,
Day, Year. The data seems to be recognized in Excel as a date because it
sorts by the the year. The format is mm/dd/yyyy. When I try to change the
format to anything else, it won't allow the change.