Try this in your Word document:

Right-click on the date field
Categories: Date and time
....set an appropriate date format that does not include a time component.
Click [OK]

Does that help?
***********
Regards,
Ron

XL2003, WinXP


"Trish" wrote:

Hi I've tried this using a date only column but when I mail merge to word it
always puts in the time element which I don't want. How can i stop this
happening.

Cheers
Trish

"Ron Coderre" wrote:

If you want to actually truncate the dates before the time stamp....

Try this:

Select the column of date/times to be impacted

From the Excel main menu:
<data<text-to-columns
Step_1: Check: Delimited..........Click [Next]
Step_2: Check: Space..............Click [Next]
Step_3: Check: Select the 2nd column (with the time in it)
..........Check: Do not import column
..........Repeat for any other columns to the right of the date
..........Click [Finish]

That will replace the Date/Time values with just the Date portion
(Remember to set the number format to one that only displays a Date)

Is that something you can work with?
***********
Regards,
Ron

XL2003, WinXP


"Nmeyer" wrote:

I have pasted data from project into excel. I have the project dates with a
time stamp 07/14/07 10:12 PM. I want to strip the time portion off from the
date. Format just changes the appearance but does not remove the hidden time
stamp.