|
How to merge monetary values from Excel to Word?
I am trying to merge an excel worksheet to Word, but when I merge the
information, such as dollar amounts, i.e. 103,801,186, I lose the commas and I have to go into each merge letter in Word and insert the commas. Is there a way to set this up in Excel so it will merge in true format? Any help would be greatly appreciated. Thanks!! |
How to merge monetary values from Excel to Word?
In Word, right click on the currency field you need to format and select EDIT
FIELD from the short-cut menu. Add the following field mask to your field, \# $####,0.0 In the example below a field named Amount is formatted for currency. MERGEFIELD Amount \# $####,0.0 -- Kevin Backmann "DSmithWBP" wrote: I am trying to merge an excel worksheet to Word, but when I merge the information, such as dollar amounts, i.e. 103,801,186, I lose the commas and I have to go into each merge letter in Word and insert the commas. Is there a way to set this up in Excel so it will merge in true format? Any help would be greatly appreciated. Thanks!! |
How to merge monetary values from Excel to Word?
Thanks so much, this is helping on one of my databases but when I use the
exact same formula on another database it's turning $2,801,220 into $3,809,374 -- I don't fully understand this formula yet but is there something that I'm missing? Thanks again! "Kevin B" wrote: In Word, right click on the currency field you need to format and select EDIT FIELD from the short-cut menu. Add the following field mask to your field, \# $####,0.0 In the example below a field named Amount is formatted for currency. MERGEFIELD Amount \# $####,0.0 -- Kevin Backmann "DSmithWBP" wrote: I am trying to merge an excel worksheet to Word, but when I merge the information, such as dollar amounts, i.e. 103,801,186, I lose the commas and I have to go into each merge letter in Word and insert the commas. Is there a way to set this up in Excel so it will merge in true format? Any help would be greatly appreciated. Thanks!! |
How to merge monetary values from Excel to Word?
It sounds like you're picking up the wrong field.
Is there any chance you have a date on that record? Is that date 04/16/2004 (or 04/17/2008 if you're using 1904 date system)? DSmithWBP wrote: Thanks so much, this is helping on one of my databases but when I use the exact same formula on another database it's turning $2,801,220 into $3,809,374 -- I don't fully understand this formula yet but is there something that I'm missing? Thanks again! "Kevin B" wrote: In Word, right click on the currency field you need to format and select EDIT FIELD from the short-cut menu. Add the following field mask to your field, \# $####,0.0 In the example below a field named Amount is formatted for currency. MERGEFIELD Amount \# $####,0.0 -- Kevin Backmann "DSmithWBP" wrote: I am trying to merge an excel worksheet to Word, but when I merge the information, such as dollar amounts, i.e. 103,801,186, I lose the commas and I have to go into each merge letter in Word and insert the commas. Is there a way to set this up in Excel so it will merge in true format? Any help would be greatly appreciated. Thanks!! -- Dave Peterson |
How to merge monetary values from Excel to Word?
After an hour of trying to figure that out, I realized it was picking up a
hidden column, it was a long day :)!! This has been extremely helpful, thanks so much!! Does anyone know the formula for %'s i.e. 2.26027%? And once I have these formulas in the field codes, will they stay or do I need to do this each time I do a mail merge? Thanks again! :) "Dave Peterson" wrote: It sounds like you're picking up the wrong field. Is there any chance you have a date on that record? Is that date 04/16/2004 (or 04/17/2008 if you're using 1904 date system)? DSmithWBP wrote: Thanks so much, this is helping on one of my databases but when I use the exact same formula on another database it's turning $2,801,220 into $3,809,374 -- I don't fully understand this formula yet but is there something that I'm missing? Thanks again! "Kevin B" wrote: In Word, right click on the currency field you need to format and select EDIT FIELD from the short-cut menu. Add the following field mask to your field, \# $####,0.0 In the example below a field named Amount is formatted for currency. MERGEFIELD Amount \# $####,0.0 -- Kevin Backmann "DSmithWBP" wrote: I am trying to merge an excel worksheet to Word, but when I merge the information, such as dollar amounts, i.e. 103,801,186, I lose the commas and I have to go into each merge letter in Word and insert the commas. Is there a way to set this up in Excel so it will merge in true format? Any help would be greatly appreciated. Thanks!! -- Dave Peterson |
How to merge monetary values from Excel to Word?
Debra Dalgleish posted this:
There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. ========== I often cheat instead of racking my brain. I'll insert another column (probably hidden!) and use: =text(a2,"0.0000%") (or whatever format I want) and use that field in the mailmerge. (Cheating doesn't bother me anymore <vbg.) DSmithWBP wrote: After an hour of trying to figure that out, I realized it was picking up a hidden column, it was a long day :)!! This has been extremely helpful, thanks so much!! Does anyone know the formula for %'s i.e. 2.26027%? And once I have these formulas in the field codes, will they stay or do I need to do this each time I do a mail merge? Thanks again! :) "Dave Peterson" wrote: It sounds like you're picking up the wrong field. Is there any chance you have a date on that record? Is that date 04/16/2004 (or 04/17/2008 if you're using 1904 date system)? DSmithWBP wrote: Thanks so much, this is helping on one of my databases but when I use the exact same formula on another database it's turning $2,801,220 into $3,809,374 -- I don't fully understand this formula yet but is there something that I'm missing? Thanks again! "Kevin B" wrote: In Word, right click on the currency field you need to format and select EDIT FIELD from the short-cut menu. Add the following field mask to your field, \# $####,0.0 In the example below a field named Amount is formatted for currency. MERGEFIELD Amount \# $####,0.0 -- Kevin Backmann "DSmithWBP" wrote: I am trying to merge an excel worksheet to Word, but when I merge the information, such as dollar amounts, i.e. 103,801,186, I lose the commas and I have to go into each merge letter in Word and insert the commas. Is there a way to set this up in Excel so it will merge in true format? Any help would be greatly appreciated. Thanks!! -- Dave Peterson -- Dave Peterson |
How to merge monetary values from Excel to Word?
I read that article earlier but didn't see anything on %'s -- did I miss it?
"Dave Peterson" wrote: Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. ========== I often cheat instead of racking my brain. I'll insert another column (probably hidden!) and use: =text(a2,"0.0000%") (or whatever format I want) and use that field in the mailmerge. (Cheating doesn't bother me anymore <vbg.) DSmithWBP wrote: After an hour of trying to figure that out, I realized it was picking up a hidden column, it was a long day :)!! This has been extremely helpful, thanks so much!! Does anyone know the formula for %'s i.e. 2.26027%? And once I have these formulas in the field codes, will they stay or do I need to do this each time I do a mail merge? Thanks again! :) "Dave Peterson" wrote: It sounds like you're picking up the wrong field. Is there any chance you have a date on that record? Is that date 04/16/2004 (or 04/17/2008 if you're using 1904 date system)? DSmithWBP wrote: Thanks so much, this is helping on one of my databases but when I use the exact same formula on another database it's turning $2,801,220 into $3,809,374 -- I don't fully understand this formula yet but is there something that I'm missing? Thanks again! "Kevin B" wrote: In Word, right click on the currency field you need to format and select EDIT FIELD from the short-cut menu. Add the following field mask to your field, \# $####,0.0 In the example below a field named Amount is formatted for currency. MERGEFIELD Amount \# $####,0.0 -- Kevin Backmann "DSmithWBP" wrote: I am trying to merge an excel worksheet to Word, but when I merge the information, such as dollar amounts, i.e. 103,801,186, I lose the commas and I have to go into each merge letter in Word and insert the commas. Is there a way to set this up in Excel so it will merge in true format? Any help would be greatly appreciated. Thanks!! -- Dave Peterson -- Dave Peterson |
How to merge monetary values from Excel to Word?
Nope. But if you've used =text() or used a custom format, I bet you could
figure it out. Maybe... MERGEFIELD Pct \# 0.0% DSmithWBP wrote: I read that article earlier but didn't see anything on %'s -- did I miss it? "Dave Peterson" wrote: Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. ========== I often cheat instead of racking my brain. I'll insert another column (probably hidden!) and use: =text(a2,"0.0000%") (or whatever format I want) and use that field in the mailmerge. (Cheating doesn't bother me anymore <vbg.) DSmithWBP wrote: After an hour of trying to figure that out, I realized it was picking up a hidden column, it was a long day :)!! This has been extremely helpful, thanks so much!! Does anyone know the formula for %'s i.e. 2.26027%? And once I have these formulas in the field codes, will they stay or do I need to do this each time I do a mail merge? Thanks again! :) "Dave Peterson" wrote: It sounds like you're picking up the wrong field. Is there any chance you have a date on that record? Is that date 04/16/2004 (or 04/17/2008 if you're using 1904 date system)? DSmithWBP wrote: Thanks so much, this is helping on one of my databases but when I use the exact same formula on another database it's turning $2,801,220 into $3,809,374 -- I don't fully understand this formula yet but is there something that I'm missing? Thanks again! "Kevin B" wrote: In Word, right click on the currency field you need to format and select EDIT FIELD from the short-cut menu. Add the following field mask to your field, \# $####,0.0 In the example below a field named Amount is formatted for currency. MERGEFIELD Amount \# $####,0.0 -- Kevin Backmann "DSmithWBP" wrote: I am trying to merge an excel worksheet to Word, but when I merge the information, such as dollar amounts, i.e. 103,801,186, I lose the commas and I have to go into each merge letter in Word and insert the commas. Is there a way to set this up in Excel so it will merge in true format? Any help would be greatly appreciated. Thanks!! -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| All times are GMT +1. The time now is 04:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com