View Single Post
  #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