deleting information from a cell

K

Katti1215

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.
 
B

BobT

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
 
Top