Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I prevent the dollar figures from mail merging w/ 10 digit
I created a worksheet with dollar amounts and when they are merged into word,
they turn into # with 10 decimal places. I tried formating the cells in a number of different ways.. but I just cannot get it to format correctly. This was supposed to be the final phase in a very long project... hopefully I can make it work! Can anyone help me? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I prevent the dollar figures from mail merging w/ 10 digit
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 "PPrincess" wrote in message ... I created a worksheet with dollar amounts and when they are merged into word, they turn into # with 10 decimal places. I tried formating the cells in a number of different ways.. but I just cannot get it to format correctly. This was supposed to be the final phase in a very long project... hopefully I can make it work! Can anyone help me? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I prevent the dollar figures from mail merging w/ 10 digit
Go back to your excel doc and retype the dollar amount using an '
(apostrophe) before each amt. ex: '$100.00 Excel will read it as exactly what is typed (but without the apostrophe) and not try to turn it into something different. It will then import into the Word doc as exactly $100.00 Hope this helps. This method can be used for any data being typed into the cell that you don't want changed (like a date). "PPrincess" wrote: I created a worksheet with dollar amounts and when they are merged into word, they turn into # with 10 decimal places. I tried formating the cells in a number of different ways.. but I just cannot get it to format correctly. This was supposed to be the final phase in a very long project... hopefully I can make it work! Can anyone help me? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I prevent the dollar figures from mail merging w/ 10 di
This is really good to know. Thanks for your advice... I will try it
sometime. I ended up copying the whole worksheet into word - as another document. It worked... what do ya know! Thanks Again & Have a Blessed Day!!! @--}--- "sccatholic" wrote: Go back to your excel doc and retype the dollar amount using an ' (apostrophe) before each amt. ex: '$100.00 Excel will read it as exactly what is typed (but without the apostrophe) and not try to turn it into something different. It will then import into the Word doc as exactly $100.00 Hope this helps. This method can be used for any data being typed into the cell that you don't want changed (like a date). "PPrincess" wrote: I created a worksheet with dollar amounts and when they are merged into word, they turn into # with 10 decimal places. I tried formating the cells in a number of different ways.. but I just cannot get it to format correctly. This was supposed to be the final phase in a very long project... hopefully I can make it work! Can anyone help me? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't get Word 2003 to keep data file with mail merge main documen | Mailmerge | |||
Edit data source icon when mail merging in Word 2003 | Mailmerge | |||
Mail merge freezes in the middle of merging | Mailmerge | |||
Mail merge dollar values | Mailmerge | |||
Mail Merging into the current or target document | Mailmerge |