Merge from excel loses formatting

[Craig]

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

 

[Doug Robbins - Word MVP]

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

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


--
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

 

[Scott]

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.

 

[Doug Robbins - Word MVP]

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

--
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