One way to try out ..

Assuming you have pasted the "dates" into col A

Select col A
Data Text to columns
Click Next Next to go to step 3 of the wizard
In step3:
Check "Date" under "Column data format",
then choose the *correct* selection from the droplist
(MDY, DMY, YMD ...)
Click Finish
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Dee" wrote in message
...
I have a spreadsheet where I want to format the cells as dates. However, I
need to paste dates from a word document into the cells. When I do this,
the
dates do not show up as the way I formatted them. Even if I apply the date
format, the correct one does not show. Is there a way to format the pasted
cells to show the correct format?

Thanks in advance for any help.