Hi Paul,

I copied 01/19/2004 from your posted line:

I can't format 01/19/2004 to read January 19, 2004, please help!!

into a number of cells in a column. I then :

1) Selected Text to Columns on the Data menu (with the cells selected!)
2) Checked the 'Fixed Width" option
3) Hit the 'Next' button
4) Hit the 'Next' button
5) Checked the 'Date' option
6) Selected 'MDY' in the dropdown
7) Hit the 'Finish' button

This converted the original text values to dates which I was then able to
format as desired.


---
Regards,
Norman



"paulonline66" wrote in message
...
Hello Norman,

I followed your instructions to the letter several times without any
success. I've pasted the values as "values", without changing any format,
and I'm unable to reformat them at all. Would this have anything to do
with
the "/"?

Thanks for your assistance, I think I'm getting closer....

"Norman Jones" wrote:

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