It's possible that you have encountered a new problem that is not described
at
http://tips.pjmsn.me.uk/t0003.htm, but it may be worth trying this
suggestion from that page on your Excel sheet (or one of the following
suggestions):
1. Format a column as text via Data|Text to Columns...
If you have a mixture of numbers and texts in a column but numbers in the
first 8 rows, you may need to get the OLE DB provider to "see" the column as
a text column. However, selecting the column and using Format|Cells to set
the format as Text does not appear to be enough. One way that does appear to
work is
- select the column
- select the Data|Text to Columns... menu option
- click Next through the wizard until you reach Step 3 of 3, then select
Text as the Column Data Format.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Onalee" wrote in message
...
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