Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
When merging from excell, how do I keep $ and no decimal
I am trying to merge an Excell spreadsheet into Word. One of my columns, is
a computed figure title Total Contact. In Word, I want the number to be in this format: $30,800. I can only get it to print in this format 30800.25. How do I do this? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
When merging from excell, how do I keep $ and no decimal
Shelly, Did you ever figure this out? I'm having the same problem, even if
I actually key the comma in the Excel file. I handled the "$" by including it in my Word file. -- sg "Shelly Reiff" wrote: I am trying to merge an Excell spreadsheet into Word. One of my columns, is a computed figure title Total Contact. In Word, I want the number to be in this format: $30,800. I can only get it to print in this format 30800.25. How do I do this? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
When merging from excell, how do I keep $ and no decimal
Press Alt+F9 to toggle on the display of the field codes and inside the
closing } at the following formatting switch: \# "$,0" For more information, 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 "Shelly Reiff" Shelly wrote in message ... I am trying to merge an Excell spreadsheet into Word. One of my columns, is a computed figure title Total Contact. In Word, I want the number to be in this format: $30,800. I can only get it to print in this format 30800.25. How do I do this? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
When merging from excell, how do I keep $ and no decimal
See response to Shelly's post.
-- 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 "sueg" wrote in message ... Shelly, Did you ever figure this out? I'm having the same problem, even if I actually key the comma in the Excel file. I handled the "$" by including it in my Word file. -- sg "Shelly Reiff" wrote: I am trying to merge an Excell spreadsheet into Word. One of my columns, is a computed figure title Total Contact. In Word, I want the number to be in this format: $30,800. I can only get it to print in this format 30800.25. How do I do this? |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
When merging from excell, how do I keep $ and no decimal
Shelly & Sueg
Add the switch to the mergefied so it will look like this: {Mergefield Amount \# "$,0;($,0)"} -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "sueg" wrote in message ... Shelly, Did you ever figure this out? I'm having the same problem, even if I actually key the comma in the Excel file. I handled the "$" by including it in my Word file. -- sg "Shelly Reiff" wrote: I am trying to merge an Excell spreadsheet into Word. One of my columns, is a computed figure title Total Contact. In Word, I want the number to be in this format: $30,800. I can only get it to print in this format 30800.25. How do I do this? |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
When merging from excell, how do I keep $ and no decimal
HI...
I also facing this problem when doing the data merge due with no decimal , it can be solve by edit the field with the formating switch, just wonder izzit any better solution to solve this , coz i will be repeating doing this mail merge with different data every months , so it's a bit troublesome for me to edit my field one by one ,monthly .... "Doug Robbins - Word MVP" wrote: Press Alt+F9 to toggle on the display of the field codes and inside the closing } at the following formatting switch: \# "$,0" For more information, 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 "Shelly Reiff" Shelly wrote in message ... I am trying to merge an Excell spreadsheet into Word. One of my columns, is a computed figure title Total Contact. In Word, I want the number to be in this format: $30,800. I can only get it to print in this format 30800.25. How do I do this? |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
When merging from excell, how do I keep $ and no decimal
You do not have to do it monthly, you just do it the one time in the
mailmerge main document. -- 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 "seagull" wrote in message ... HI... I also facing this problem when doing the data merge due with no decimal , it can be solve by edit the field with the formating switch, just wonder izzit any better solution to solve this , coz i will be repeating doing this mail merge with different data every months , so it's a bit troublesome for me to edit my field one by one ,monthly .... "Doug Robbins - Word MVP" wrote: Press Alt+F9 to toggle on the display of the field codes and inside the closing } at the following formatting switch: \# "$,0" For more information, 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 "Shelly Reiff" Shelly wrote in message ... I am trying to merge an Excell spreadsheet into Word. One of my columns, is a computed figure title Total Contact. In Word, I want the number to be in this format: $30,800. I can only get it to print in this format 30800.25. How do I do this? |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
When merging from excell, how do I keep $ and no decimal
Hi Doug ,
mean i jz update my field and add the switch once on my master file will do rite ? "Doug Robbins - Word MVP" wrote: You do not have to do it monthly, you just do it the one time in the mailmerge main document. -- 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 "seagull" wrote in message ... HI... I also facing this problem when doing the data merge due with no decimal , it can be solve by edit the field with the formating switch, just wonder izzit any better solution to solve this , coz i will be repeating doing this mail merge with different data every months , so it's a bit troublesome for me to edit my field one by one ,monthly .... "Doug Robbins - Word MVP" wrote: Press Alt+F9 to toggle on the display of the field codes and inside the closing } at the following formatting switch: \# "$,0" For more information, 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 "Shelly Reiff" Shelly wrote in message ... I am trying to merge an Excell spreadsheet into Word. One of my columns, is a computed figure title Total Contact. In Word, I want the number to be in this format: $30,800. I can only get it to print in this format 30800.25. How do I do this? |
#9
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
When merging from excell, how do I keep $ and no decimal
Yes, you just need to modify the fields in the mailmerge main document the
one time. -- 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 "seagull" wrote in message ... Hi Doug , mean i jz update my field and add the switch once on my master file will do rite ? "Doug Robbins - Word MVP" wrote: You do not have to do it monthly, you just do it the one time in the mailmerge main document. -- 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 "seagull" wrote in message ... HI... I also facing this problem when doing the data merge due with no decimal , it can be solve by edit the field with the formating switch, just wonder izzit any better solution to solve this , coz i will be repeating doing this mail merge with different data every months , so it's a bit troublesome for me to edit my field one by one ,monthly .... "Doug Robbins - Word MVP" wrote: Press Alt+F9 to toggle on the display of the field codes and inside the closing } at the following formatting switch: \# "$,0" For more information, 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 "Shelly Reiff" Shelly wrote in message ... I am trying to merge an Excell spreadsheet into Word. One of my columns, is a computed figure title Total Contact. In Word, I want the number to be in this format: $30,800. I can only get it to print in this format 30800.25. How do I do this? |
#10
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
When merging from excell, how do I keep $ and no decimal
ok..thanks you very much ...Douh Robbins
"Doug Robbins - Word MVP" wrote: Yes, you just need to modify the fields in the mailmerge main document the one time. -- 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 "seagull" wrote in message ... Hi Doug , mean i jz update my field and add the switch once on my master file will do rite ? "Doug Robbins - Word MVP" wrote: You do not have to do it monthly, you just do it the one time in the mailmerge main document. -- 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 "seagull" wrote in message ... HI... I also facing this problem when doing the data merge due with no decimal , it can be solve by edit the field with the formating switch, just wonder izzit any better solution to solve this , coz i will be repeating doing this mail merge with different data every months , so it's a bit troublesome for me to edit my field one by one ,monthly .... "Doug Robbins - Word MVP" wrote: Press Alt+F9 to toggle on the display of the field codes and inside the closing } at the following formatting switch: \# "$,0" For more information, 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 "Shelly Reiff" Shelly wrote in message ... I am trying to merge an Excell spreadsheet into Word. One of my columns, is a computed figure title Total Contact. In Word, I want the number to be in this format: $30,800. I can only get it to print in this format 30800.25. How do I do this? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell | Tables | |||
How do I keep Excell tel nmbr formatting when merging to Word? | Mailmerge | |||
How do I keep the % format when merging from excell into word? | Mailmerge | |||
Word adds extra decimal places to number fields when merging why? | Mailmerge | |||
how do I get decimal points to show in word merging from excel? | Mailmerge |