View Single Post
  #2   Report Post  
Norman Jones
 
Posts: n/a
Default

Hi Paul,

"paulonline66" wrote in message
...
I can't format 01/19/2004 to read January 19, 2004, please help!!
Dragged and dropped a series of dates and now I can't convert them to sort
them properly. What to do??



With the date cells selected:

Data | Text to Columns | Next | Next | Select the Date option and Select
the DMY option in the dropdown box | Finish

---
Regards,
Norman