[Look2TheSky2]

I am merging data from an Excel worksheet into a Word document. Although the
time data in Excel is formatted as h:mm AM/PM, the same time presented in the
merged document appears as h:mm:ss AM/PM.

I think I need to use a switch in the merged field to reformat it to the
preferred h:mm AM/PM.

On the merge document, the field looks like this (after alt-f9) ....
{MERGEFIELD "Start_Time"}.

I do not know how or where to insert the switch (\@ "h:mm AM/PM)??

Thanks in advance for your help. A simple problem, but one I am struggling
with.

[Dawn Crosier, Word MVP]

Insert it after the second quote mark in your field, and before the
closing French brace.

See also http://word.mvps.org/FAQs/MailMerge/index.htm for further
clarification

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and questions
to the newsgroup so that others can learn as well.




"Look2TheSky2" wrote in message
:

I am merging data from an Excel worksheet into a Word document. Although the
time data in Excel is formatted as h:mm AM/PM, the same time presented in the
merged document appears as h:mm:ss AM/PM.

I think I need to use a switch in the merged field to reformat it to the
preferred h:mm AM/PM.

On the merge document, the field looks like this (after alt-f9) ....
{MERGEFIELD "Start_Time"}.

I do not know how or where to insert the switch (\@ "h:mm AM/PM)??

Thanks in advance for your help. A simple problem, but one I am struggling
with.

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.31/1031 - Release Date: 9/26/2007 12:12 PM

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.31/1031 - Release Date:
9/26/2007 12:12 PM

[Doug Robbins - Word MVP]

Thanks, Dawn.

I have been looking for a name to call { } and Googling for French Brace
does turn a few (only a few mind you) hits that support the use of that
term.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Dawn Crosier, Word MVP" wrote in message
...
Insert it after the second quote mark in your field, and before the
closing French brace.

See also http://word.mvps.org/FAQs/MailMerge/index.htm for further
clarification

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and questions
to the newsgroup so that others can learn as well.




"Look2TheSky2" wrote in message
:

I am merging data from an Excel worksheet into a Word document. Although
the
time data in Excel is formatted as h:mm AM/PM, the same time presented in
the
merged document appears as h:mm:ss AM/PM.

I think I need to use a switch in the merged field to reformat it to the
preferred h:mm AM/PM.

On the merge document, the field looks like this (after alt-f9) ....
{MERGEFIELD "Start_Time"}.

I do not know how or where to insert the switch (\@ "h:mm AM/PM)??

Thanks in advance for your help. A simple problem, but one I am
struggling
with.

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.31/1031 - Release Date:
9/26/2007 12:12 PM

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.31/1031 - Release Date:
9/26/2007 12:12 PM

[macropod]

Hi Doug,

Mostly I think you'll find they're just called braces.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Doug Robbins - Word MVP" wrote in message ...
Thanks, Dawn.

I have been looking for a name to call { } and Googling for French Brace
does turn a few (only a few mind you) hits that support the use of that
term.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Dawn Crosier, Word MVP" wrote in message
...
Insert it after the second quote mark in your field, and before the
closing French brace.

See also http://word.mvps.org/FAQs/MailMerge/index.htm for further
clarification

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and questions
to the newsgroup so that others can learn as well.




"Look2TheSky2" wrote in message
:

I am merging data from an Excel worksheet into a Word document. Although
the
time data in Excel is formatted as h:mm AM/PM, the same time presented in
the
merged document appears as h:mm:ss AM/PM.

I think I need to use a switch in the merged field to reformat it to the
preferred h:mm AM/PM.

On the merge document, the field looks like this (after alt-f9) ....
{MERGEFIELD "Start_Time"}.

I do not know how or where to insert the switch (\@ "h:mm AM/PM)??

Thanks in advance for your help. A simple problem, but one I am
struggling
with.

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.31/1031 - Release Date:
9/26/2007 12:12 PM

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.31/1031 - Release Date:
9/26/2007 12:12 PM

[Graham Mayor]

Or with relation to merge, field boundaries or brackets.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


macropod wrote:
Hi Doug,

Mostly I think you'll find they're just called braces.

Cheers

"Doug Robbins - Word MVP" wrote in message
...
Thanks, Dawn.

I have been looking for a name to call { } and Googling for French
Brace does turn a few (only a few mind you) hits that support the
use of that term.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Dawn Crosier, Word MVP" wrote in message
...
Insert it after the second quote mark in your field, and before the
closing French brace.

See also http://word.mvps.org/FAQs/MailMerge/index.htm for further
clarification

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and
questions to the newsgroup so that others can learn as well.




"Look2TheSky2" wrote in
message :

I am merging data from an Excel worksheet into a Word document.
Although the
time data in Excel is formatted as h:mm AM/PM, the same time
presented in the
merged document appears as h:mm:ss AM/PM.

I think I need to use a switch in the merged field to reformat it
to the preferred h:mm AM/PM.

On the merge document, the field looks like this (after alt-f9)
.... {MERGEFIELD "Start_Time"}.

I do not know how or where to insert the switch (\@ "h:mm AM/PM)??

Thanks in advance for your help. A simple problem, but one I am
struggling
with.

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.31/1031 - Release Date:
9/26/2007 12:12 PM

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.31/1031 - Release Date:
9/26/2007 12:12 PM

[Dawn Crosier, Word MVP]

Hi Doug -

I don't remember when I learned the term ~ it's been a long time ago.

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and questions
to the newsgroup so that others can learn as well.


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.32/1033 - Release Date:
9/27/2007 11:06 AM

[macropod]

Hi,

Try:
{MERGEFIELD "Start_Time" \@ "h:mm AM/PM"}.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Look2TheSky2" wrote in message ...
I am merging data from an Excel worksheet into a Word document. Although the
time data in Excel is formatted as h:mm AM/PM, the same time presented in the
merged document appears as h:mm:ss AM/PM.

I think I need to use a switch in the merged field to reformat it to the
preferred h:mm AM/PM.

On the merge document, the field looks like this (after alt-f9) ....
{MERGEFIELD "Start_Time"}.

I do not know how or where to insert the switch (\@ "h:mm AM/PM)??

Thanks in advance for your help. A simple problem, but one I am struggling
with.

[Look2TheSky2]

Works like a charm!!! Thank you everyone!

"macropod" wrote:

Hi,

Try:
{MERGEFIELD "Start_Time" \@ "h:mm AM/PM"}.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Look2TheSky2" wrote in message ...
I am merging data from an Excel worksheet into a Word document. Although the
time data in Excel is formatted as h:mm AM/PM, the same time presented in the
merged document appears as h:mm:ss AM/PM.

I think I need to use a switch in the merged field to reformat it to the
preferred h:mm AM/PM.

On the merge document, the field looks like this (after alt-f9) ....
{MERGEFIELD "Start_Time"}.

I do not know how or where to insert the switch (\@ "h:mm AM/PM)??

Thanks in advance for your help. A simple problem, but one I am struggling
with.

[WordBanter AI]

Reformatting Time in a Merged Document

Hi there! I can definitely help you with this issue.

To reformat the time in your merged document, you can use the switch you mentioned (\@ "h:mm AM/PM"). Here's how you can insert it into your merge field:

1. In your Word document, select the merge field that displays the time data (in your case, {MERGEFIELD "Start_Time"}).
2. Press Alt+F9 to toggle the field code view.
3. At the end of the merge field, add a space and then type \@"h:mm AM/PM" (without the quotes).
4. Press Alt+F9 again to toggle back to the merged data view.

Your merge field should now look something like this:

{MERGEFIELD "Start_Time" \@ "h:mm AM/PM"}

When you preview or complete the merge, the time data should now be formatted as h:mm AM/PM.