How do I Align the Decimals in the Grant and Contributions Area of my Fund Statements?
  • 18 Jan 2023
  • Contributors
  • Dark
    Light
  • PDF

How do I Align the Decimals in the Grant and Contributions Area of my Fund Statements?

  • Dark
    Light
  • PDF

Article summary

When I merge my fund statements, I noticed that the decimal points are not aligned. How can I align them?

Here is how they look when they are not aligned:

Answer:

In order to align the decimals in the grants or contributions area, do the following steps BEFORE running the eadvisorfundstatements2007 macro to create the PDFs to upload to DonorCentral:

1. Highlight the dollar amounts in the Amount columns
2. On the top menu in Word, go to the Home tab, then paragraph group.
3. Click on Align Right

Note: A global way to do this for all statements is to run the right flush macro on your merged letters prior to running the macro to create the pdfs, see the following:

How do I right flush the gift and grant amounts in the detail section of fund statements?

See these results: 



Was this article helpful?