I suspect that you have name values overlapping each other. The Name Payee_1 does print the Vendors name but the address. The Named Range Address displays the address only. In the original template, key press CTRL F3 to review the Named Ranges and compare with the named ranges in your modified template.

Changing the date format in excel can be accomplished by right mouse clicking on the cell and selecting Format Cells (key press CTRL 1) and then select Date and choose your desired date format.

To make text invisible for printing requires that the cells be formatted with white text using Format Cells > Font > Color and selecting white.

Regards to All,