Hi Jane,
To get the time format you want, you can add a formatting picture switch. In Word:
.. select the mergefield;
.. press Shift-F9 to expose the field coding. It should look something like {MERGEFIELD MyTime} where 'MyTime' is your mergefield's
name;
.. delete anything appearing after the mergefield's name and add '\[ at ] "h:m"', as in {MERGEFIELD MyTime \[ at ] "h:m am/pm"}.Note: you must
use lowercase 'm's for minutes;
.. if you want the hours and/r minutes to display leading 0s, change 'h' to 'hh for hours and 'm' to 'mm' for minutes;
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.
--
Cheers
macropod
[MVP - Microsoft Word]
"Jane" <Jane[ at ]discussions.microsoft.com> wrote in message news:6B168517-661E-423A-AB21-D44C735DBBDB[ at ]microsoft.com...
[Quoted Text] >I formatted the cells in Excel with h:mm BUT when I mail merge into Word it
> comes out as h:mm:ss AM. I don't want the seconds or the AM or PM. Can
> anyone tell me where I've gone wrong. It's driving me mad so any feedback
> will be great
|