[MaxArk[_27_]]

I am merging a time value into a mail merge document from an Excel
source.
Despite my merge field being formatted {MERGERFIELD"SubRespEnd"\@ "h:mm
am/pm" } 12:00AM is being displayed as 1/1/1900.

Is anyone able to shed some light on the cause and a possible solution?




--
MaxArk

[Doug Robbins - Word MVP]

What is the data source?

Using Office 2007 with an data in an Excel spreadsheet with the cells
containing the data formatted as *1:30:55 PM, so that entering 0 in a cell
displays 12:00:00 AM and then using that spreadsheet as a mail merge data
source without any formatting switch, the data is displayed in the Word
document as 12:00:00 AM. Adding the \@ "h:mm AM/PM" switch to the field,
it is displayed as 12:00 AM

If I use a custom format h:mm AM/PM in Excel, 0 entered into a cell displays
as 12:00 AM and the behaviour when it is merged into Word is identical to
the above, 12:00:00 AM without the switch and 12:00 AM with it.

This holds for both a DDE connection to the data source as well as an OLE DB
(Database) connection.

--
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, originally posted via msnews.microsoft.com

"MaxArk" wrote in message
...

I am merging a time value into a mail merge document from an Excel
source.
Despite my merge field being formatted {MERGERFIELD"SubRespEnd"\@ "h:mm
am/pm" } 12:00AM is being displayed as 1/1/1900.

Is anyone able to shed some light on the cause and a possible solution?




--
MaxArk