Thank so much for your help, Bruce, but how do i merging using 'from xl as
DDE'? i am sorry because i am really not much a expert using excel. Are
there any steps by steps that you can show me? Am i asking too much from
you? If i do, then just ignore it, and i really appreciated you taking your
time to answer it.

Lynn

"Bruce Sinclair" wrote:

In article , "David Biddulph" <groups [at] biddulph.org.uk wrote:
The merge merely picks up the cell contents as a number, not the formatting.
I find that the easiest way of dealing with this is to produce a helper
column using the TEXT() function to specify the required format, and then
use that column as your data source for the merge.

I believe that there are ways of specifying field formats within Word, but
I'll leave Word experts to tell you about that route.

Try merging using 'from xl as DDE' too instead of one of the other options.
It's not the default IIRC and it doesn stop at least some of those annoying
formatting problems ... at least it did for me. :)