Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Time Staying in Format
I currently do mail merges to allow a template using fields from excel to be
printed to make life easier. For some reason thou if my field is set in a time format when if comes to word it converts to a decimal form. example the time is 17:00 it comes as .5. Help is greatly appreciated. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...merge/200709/1 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Time Staying in Format
See http://tips.pjmsn.me.uk/t0003.htm for a (long) explanation of this
problem -the DDE approach described there is likely to be the simplest fix. Although "0.5" does not seem quite right for 17:00 the likley origin of the problem is if the OLE DB provider has decided on the basis of the first 8 rows of data that the column should be regarded as numeric rather than date/time. -- Peter Jamieson http://tips.pjmsn.me.uk "Darrell_Sarrasin via OfficeKB.com" u33691@uwe wrote in message news:77b96ed5166ca@uwe... I currently do mail merges to allow a template using fields from excel to be printed to make life easier. For some reason thou if my field is set in a time format when if comes to word it converts to a decimal form. example the time is 17:00 it comes as .5. Help is greatly appreciated. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...merge/200709/1 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get rid of a format that appears each time on a new doc? | Page Layout | |||
Time field format | Mailmerge | |||
Format Date and Time to show Military Time | Microsoft Word Help | |||
Date and time format | Microsoft Word Help | |||
Time Format | Mailmerge |