Merge from excel loses formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Craig - 09 Jan 2006 19:50 GMT

I am running a merge with excel and word 2000, when I merge a field from
excel in the format $300.10 it merges i into word as 300.1

Im pretty new to this so any help appreciated

CR

Reply to this Message

Doug Robbins - Word MVP - 09 Jan 2006 21:01 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

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

>I am running a merge with excel and word 2000, when I merge a field from
> excel in the format $300.10 it merges i into word as 300.1
>
> Im pretty new to this so any help appreciated
>
> CR

Reply to this Message

Scott - 23 Feb 2006 21:17 GMT

Craig, a quick way to fix your ploblem is to format your fields in excel then
save your file as a txt file, delete your table, then inport your txt file
setting all the fields to text fields. The formating will be used in word.

> I am running a merge with excel and word 2000, when I merge a field from
> excel in the format $300.10 it merges i into word as 300.1
>
> Im pretty new to this so any help appreciated
>
> CR

Reply to this Message

Doug Robbins - Word MVP - 24 Feb 2006 16:21 GMT

I seriously doubt that it is a quick as adding a formatting switch to the
field codes.

Signature

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

> Craig, a quick way to fix your ploblem is to format your fields in excel
> then
[quoted text clipped - 7 lines]
>>
>> CR

Reply to this Message