Problem: I added the custom header Profit & Loss Report to my report.
- Include an ampersand in the header.
However, the actual header appears as Profit Loss Report. The ampersand is missing.
- Excel leaves out the &.
Strategy: The ampersand is a special character in the custom header and footer field. To print an ampersand in the header, you have to type && in the Header dialog box.
- Specify && while editing the header.
Having two ampersands will give you the desired heading Profit & Loss.
- Excel will print the && as a single &.