I am using an excel spreadsheet as my data source in a Word document mail merge. I have formatted the amounts in excel as currency with 2 decimal places. Formatting Page Numbers in Microsoft Word 2007, 2010, 2013 Open your MS Word document Remove any previously created section breaks, headers/footers and page numberings.

Then use the auto- fill to copy the formula down all the rows.. I dont understand why you cant get it to look right using the format menu, there is a currency option in there, that I have never had problems with.

Using styles might seem like too much effort. A mail merge allows you to send personalized messages to a large group of people at once without them knowing who else you have sent it to. This is a great way to. Use an existing file or import a.txt or.csv file as your data source for a Word mail merge. Then prepare the data properly to make sure numerical data like. Using Access Visual Basic to perform Microsoft Word mail merge give you the ultimate control and alleviates the need to jump to Microsoft Word to perform the mail merge. Do you know What is excel conditional formatting? Learn the basics, few examples and see how you can use it in day to day work in this installment of. Testing for a value in one of several fields. Sometimes when preparing a mail merge document, you may wish to insert text based upon whether a value has been inserted.

I understand the problem isn't in excel. Hack Donkey Kong Country 3 Dixie more. Theres a hundred ways to skin a cat of course, but fixing the prob from data end saves formatting every word doc with special chars..

How to Change the Orientation of Text in Microsoft Word. Changing your text orientation can be useful if you want to create sidebars in a newsletter, tear-off tabs at. This post is about an interesting problem that came to me by e-mail about a mail merge problem in Microsoft Word. Someone from a training company wanted to send out.

Sorry if I offended ya Charlie, only offering my $0.