Formatting Numbers in a Merge Field in Microsoft Word
at
12:01 AM
You might already know how powerful the "Mail Merge" function of the Microsoft Word is!
With only a single "letter" (assuming you are writing a letter), you can print it for a thousand recipients without manually typing all the names, addresses and other unique information. Isn't that awesome?
This article assumes that you are already familiar with, and already using the mail merge.
Formatting Prices with a “Numeric Picture Switch”
Numbers don’t always automatically display with the correct formatting (currency, decimals, etc.). To fix that:
- On your original source document (before completing the merge), right-click on the field and select “Toggle Field Codes.”
- It will look something like this (where “Price” is your particular field name):
{ MERGEFIELD “Price” } - Place your cursor before the closing bracket and type:
\# $,#.00(There is a space between the first # and the $.) - It should now look like:
{ MERGEFIELD “Price” \# $,#.00 } - Right-click on the field name once again and select “Toggle Field Codes” to return to the original view. Your prices should now display appropriately.
What do the Symbols Mean?
$ - The character to display at the beginning of the number (in this case, a dollar sign).
, - Indicates that you want commas to designate thousands.
# - The number of number signs (#) typed after the comma indicate the number of digits that should be forced to display.
.00 - Indicates that you want to include a decimal point to two places with each number. Anytime a number to be merged doesn’t include decimals, it will display with zeros.
What can you say about this tip? Let us know! :)
Heard of 
We have no satisfaction. Contentment is just something cannot be easily satisfied. Despite of the fact that we already have something good, we want something better or something more.
Disappointment is pretty common in my everyday work life. It's normal, I am full of hopes, dreams and expectations. I expect, I look forward, and I trust everything is alright.
It is when you stop going along with the crowd and start realizing that there are many things about yourself that you didn’t know and may not like. You start feeling insecure and wonder where you will be in a year or tow, but then get scared because you barely know where you are now.
Are you an employed accountant or a practicing accountant or unemployed accountant and you think you are earning less than what you need? Or you may be earning more than what you need, but less than what you want? Or just say you want to expand your clientele?
Good news to WordPress users using custom domain! You can now create your custom e-mail address using your custom domain and have the e-mails sent to these custom domain to your existing email address. That's the power of e-mail forwarding. Since it's free, this only support up to five (5) forwarding rules.
Just recently, news discussing 
Sigh... Sometimes that's the only thing you can do when you want to hide the frustration that is insisting to reach out from your very deep inside.
Posts
