[Doug Robbins - Word MVP]

It is the change in data type (the set up of the columns to General is only
for appearance) that is causing your problem. Copying and pasting the data
into a Word document as Peter suggests would be a simple way of overcoming
the issue.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"jlem102" wrote in message
news
New news...The data source columns are all set up as General in excel.
Column starts with data as ie. 12345, then data changes to i.e. 123K5, so
when you pull the data into word as a word merge, the columns of data
mysteriouly changes data to zeros when the data changed to 123k5 type
data.
Had to break down the merged file into pages and manually key in data
needed.
Not fun !
--
jlem102


"Peter Jamieson" wrote:

As long as the number of columns is reasonably small, it is probably
simplest to edit-copy your sheet, or the columns you are using, then
edit-paste into a new Word document. The data should appear as a table
(unless you have too many columns). Save that, and use it as the data
source for your merge.

Peter Jamieson

http://tips.pjmsn.me.uk

On 12/03/2010 22:20, jlem102 wrote:
Have an 8 pg custom Label word merge doc w/excel file as data source.
First
page prints all data perfectly of 4 short lines. 2nd page& rest of
doc.
places a zero in a field that should have (example) 354k4. Field is
formatted
as General. Don't know why the number/letter combo isn't appearing,
instead
shows as a zero.
.