Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge from excel loses formatting
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge from excel loses formatting
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 "Craig" wrote in message ... 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge from excel loses formatting
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. "Craig" wrote: 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 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge from excel loses formatting
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 "Scott" wrote in message ... 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. "Craig" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel to Word Merge probelm | Mailmerge | |||
Mail Merge w/ Excel Data | Microsoft Word Help | |||
2003 Small Business - Mail Merge from Excel Sheet Duplication Oddi | Mailmerge | |||
Formatting zip code in mail merge from Excel to Word | Microsoft Word Help | |||
formatting links from excel into word (extra line feeds) | Microsoft Word Help |