WORD Thousand Separator Merged Fields
Solved
bibike
-
Shaaa -
Shaaa -
Hello,
I created a mail merge in Word to follow up with clients.
My database is set up in Excel, divided into three tabs, with different letters for each type of follow-up.
I have a field indicating the amount of debt in the letter, which is nice as it appears correctly, but it is not formatted.
In my database, this field is written as: "10 658,40 €" and I would like it to keep the thousand separator and the euro symbol in Word, yet it displays as "10658,4".
By pressing alt+F9, I was able to write in the macro (is that what it's called??) this code "/# "## ###,## €"}"
The € symbol appears, but my number which was 10 658.40 €, reduces to "106.58 €", it shifts and truncates, and still does not separate the thousands. I have searched on faqworld and many other sites online but I can't find an answer to my problem.
If I use the mail merge wizard, I should be able to get this formatting, but I can't redo my three-tab table in Word, and given the length, I would like to avoid that.
If anyone can help me, I am all ears.
Thank you in advance for your reading and responses.
I created a mail merge in Word to follow up with clients.
My database is set up in Excel, divided into three tabs, with different letters for each type of follow-up.
I have a field indicating the amount of debt in the letter, which is nice as it appears correctly, but it is not formatted.
In my database, this field is written as: "10 658,40 €" and I would like it to keep the thousand separator and the euro symbol in Word, yet it displays as "10658,4".
By pressing alt+F9, I was able to write in the macro (is that what it's called??) this code "/# "## ###,## €"}"
The € symbol appears, but my number which was 10 658.40 €, reduces to "106.58 €", it shifts and truncates, and still does not separate the thousands. I have searched on faqworld and many other sites online but I can't find an answer to my problem.
If I use the mail merge wizard, I should be able to get this formatting, but I can't redo my three-tab table in Word, and given the length, I would like to avoid that.
If anyone can help me, I am all ears.
Thank you in advance for your reading and responses.
Configuration: Windows XP Internet Explorer 6.0
8 réponses
Hello,
Word doesn't care about Excel formatting, you really need to impose the correct formatting
the numeric switch of the field (and not the macro code as there is no macro...) is poorly done. You should put:
\# "## ###,00 €"
However, I feel like you're mixing up the decimal separator (dot or comma??). The latter must comply with regional and linguistic options.
m@rina
Word doesn't care about Excel formatting, you really need to impose the correct formatting
the numeric switch of the field (and not the macro code as there is no macro...) is poorly done. You should put:
\# "## ###,00 €"
However, I feel like you're mixing up the decimal separator (dot or comma??). The latter must comply with regional and linguistic options.
m@rina
I won't hide that I lost more than a day before finding your trick. From my heart, I wish you that God rewards you.