Deirdre has attended:
Excel Advanced course
Mail merge using Excel
Hello,
I'm trying to use mail-merge to compile a large group of letters. One of the columns contains amounts of money. This column is formatted to have two decimal places on excel.
When I carry out the merge, numbers where the second decimal place is 0 are coming through in the format XX.X rather than XX.XX.
Can you tell me how to ensure that numbers come through in the formal XX.XX?
Thanks
Deirdre
RE: Mail merge using Excel
Hi Deirdre,
Thank you for your question.
I am currently looking at the question it in my breaks and lunch and have not found a way to ensure the format stays the same.
As soon as I find a solution, I will email you.
Regards
Simon
RE: Mail merge using Excel
Hi Dierdre,
Sorry for the delay in responding.
Have you managed to resolve your problem?
I have found a possible solution. Please try this:
1. Add the mail merge fields.
2. Use Alt + F9 to show the merge codes
3. e.g. {MERGEFIELD "Fieldname" }
4. Change the code for the cash field to this:
5. {MERGEFIELD "Fieldname"\#0.00x}
This should format the cash field to show two decimal places.
I hope this answers your question.
Regards
Simon
