View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MikeOneill MikeOneill is offline
external usenet poster
 
Posts: 2
Default Importing dates and military time from Excel into word doc mail me

I am trying to import dates and military time contained in individual cells
into a word document using mail merge. The files are merged from an excel
spreadsheet and appear correctly on the spreadsheet. ie; column 1 :
08-12-2006 column #2: 2000 column #3 : 2130 hrs. When I merge the documents I
get column #1
08-12-2006 12:00:00 AM ( 12:00:00 AM appears every time ) and arbitrary
numbers or dates for column #2 and #3. Is there an explanation and a fix?