As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
Hi, I'm having a issue with a excel column heading which is relatively long(see below). It prints with a special character(square box) in the heading where I have commas to print the heading in next line.
TABLE FILE TABLE A SUM EXER_NUM_US AS 'No.of Policies,Exercising,GPO - YTD (US)' BY YEAR BY ISS_YR END -RUN
IT PRINTS AS "No.of Policies(square box)Eligible for(square box)GPO - YTD (US)"
When i double click the column in excel it looks good but when we first open the report it shows as above and the user is not happy with it.
Any help or suggestions is appreciated!
Thank you RKThis message has been edited. Last edited by: Kerry,
we use EXCEL 2007. The problem is, this error doesn't occur all the time. Most of the time it occurs in caster jobs. When I run the report it print's ok but the same report from caster sometimes it prints out with small square character. Not sure why this error is inconsistent.