Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
We have a pivot table which has a list of date/times used as the columns. The problem is that when selecting a wider range the columns become too narrow to read the full date and is cutting off the year (see screenshot).
Is there a way to force the columns to stay slightly wider so that you can read the full content?
Thanks
Hi, @Dan_A
concatenate your column with the space you want it to occupy
column & ' '
or with chr(10)&chr(13)