On Feb 17, 4:21*pm, bmelt wrote:
How to disable displaying ### instead of number
in a narrow column?

As others have noted, this is simply telling you that the column is
not wide enough.

Unfortunately, sometimes this arises when you would not expect it.
For example, reducing the view zoom magnification percentage sometimes
causes "###" in some columns.

To avoid that, I have had great success by using the Terminal font.
That is a non-proportional font. There are non-proportional; but they
still sometimes result in "###" indicators, surprisingly.

More generally, if you select the offending columns (or all columns)
and click on Format Column Autofit, you can eliminate the "###"
indicators when they arise.

If the "###" indicators arise when you are using VBA macros and
functions, someone can tell you what you can add to them to avoid the
"###" indicators.

Also, someone can probably tell you how to create an event macro that
will automatically do the column Autofit after changes. But that
might be overkill, unless the event macro can be made to do that only
when needed. Unfortunately, I am not savvy about such things.