Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Onalee Onalee is offline
external usenet poster
 
Posts: 5
Default Merge Excel/Word 2007, getting 12:00AM in merge which is NOT in ex

Hi,
I am merging data from excel into a word document. I am getting data in
word that is showing "12:00AM", however, there is data in the excel sheet and
it is NOT a date and it is not blank - it is part of an address line, such as
"Deliver to Front Desk" or any kinds of words, but definately not a date and
not blank.

I have tried re-typing the data in excel, I have even put a " ' " in front
of it to show it is text - nothing gets rid of this . It doesn't do it on
every field or even every record on the same field, just some and seemingly
randomly.

Any idea how to fix this other than manually changing the data in the final
merged document?

Thanks ,
Onalee
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
format field percentage merge Word 2007 from excel 2007 LoisInAlaska Mailmerge 3 September 15th 08 06:47 PM
Mail Merge Labels (Word 2007) w/ Excel (2007) aedcone Microsoft Word Help 2 August 11th 08 03:14 PM
Mail Merge Labels (Word 2007) from Excel (2007) aedcone Microsoft Word Help 3 August 8th 08 03:29 PM
Merge excel 2007 to word 2007 in labels Paula Mailmerge 1 October 17th 07 06:03 AM
mail merge freezes when completing merge - using excel 2007 as sou traci Mailmerge 0 June 19th 07 06:34 PM


All times are GMT +1. The time now is 12:46 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"