I rec'd an excel spreadsheet and one of the columns has a date and time in
it. I am trying to do a mail merge and don't want the time to be in the
letter. Is there anyway to format this cell to remove the time. I have
tried to format the cell and click only the date as an option, but the time
still shows in the cell. Thank you.

I'm just guessing here, but it sounds like you have a column that shows:

01/25/2007 13:41

And you just want it to show/read in your mail merge:

01/25/2007 or maybe Jan. 25, 2007

Keeping in Excel, you could, in another column enter the following formula:

=TEXT(E2,"mmm dd, yyyy")

Where E2 is a cell with the date and time in it. Then either use that
column in your mail merge or do a COPY | Paste Special and choose Value over
top the original values.

Bob Tulk
MOUS

"Katti1215" wrote:

I rec'd an excel spreadsheet and one of the columns has a date and time in
it. I am trying to do a mail merge and don't want the time to be in the
letter. Is there anyway to format this cell to remove the time. I have
tried to format the cell and click only the date as an option, but the time
still shows in the cell. Thank you.