Showing 3:54PM instead of 3:54:03PM

T

TJ

How do you get rid of the seconds in the time area. I have changed the
formatting in the time. I use the excel file as a data source. I include the
time in the mail merge. It always shows up with the seconds in the time. Very
frustrating.
HELP PLEASE!!

TJ
 
E

Eddie O

it may be formatted as text, so won't respond to changing the time format.
if it is text, the TIMEVALUE formula will convert it to a decimal-based time
value which can then be formatted by using Excel's normal Number formatting--
to get rid of the seconds.

Eddie O
 
B

Bryan Hessey

Your problem is that with Dates and Times you are formatting the view of
the cell, not the cell contents.

To format the time as a reformatted cell content try (for the current
time):
=TEXT((NOW()),"hh")&":"&TEXT((NOW()),"mm")&"PM"

or, assuming your time is in a cell (say, cell C8)
=TEXT(C8,"hh")&":"&TEXT(C8,"mm")&"PM"

Hope this helps
 
D

Dave Peterson

Debra Dalgleish posted this for a different question:

In the Mail Merge, after you select your Excel file as a data source,
you should see a 'Confirm Data Source' dialog box.
(If you don't see the dialog box, change the setting in Word --
under Tools>Options, General -- add a check mark to
'Confirm Conversion at Open')

From that list, choose 'MS Excel Worksheets via DDE (*.xls)', and your
formatting will be retained.

If you have to connect through a different source, you can format the
fields in the Word document. For example, to specify a number of decimals:

1. In Word, in the Main Document, press Alt+F9 to view the field codes.
2. Find the field code for the number. It will look something like:
{ MERGEFIELD FieldName }
3. Add a switch, to format the number with two decimal places.
For example:
{ MERGEFIELD FieldName \# "#,##0.00" }
4. Press Alt+F9 to hide the field codes.
5. Save the Main Document

You'll have to change the format to what you need.

=====
I read the mailmerge help in Word and this format worked ok for me:
{ MERGEFIELD FieldName \@ "hh:mm am/pm" }
 
Top