How to disable displaying ### instead of number in a narrow column?

hi
you can't so far as i know. widen the column.

Regards
FSt1

"bmelt" wrote:

How to disable displaying ### instead of number in a narrow column?

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

### is not an error, excel is telling you the number does not fit,

This seems to work it will show a blank if there are more than 3
characters

=IF(LEN(A1+A2)3,"",A1+A2)

I suppose this would work as well

=if(a1+a2999"",a19+a2)
Both of these won't work well because if there are decimals in the
cells then there would be more than 3 integers such as 22.5

So the other option would be conditional formatting

This will set the conditional format if there are more than 3
character in the Cell B1:B13

Then you could set the font to white if the condition is met.
Select the range to format, in this example select B1:B13
Goto Format=conditional Format
Formula is
=LEN(B1:B13)3
then select the format button and make the font white if condition is
met.

What do you want it to display?

Regards,
Fred.

"bmelt" wrote in message
...
How to disable displaying ### instead of number in a narrow column?

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.

If the ###'s are caused by the number being too wide for the column, you could
change the font size.

In xl2003 menus, you can use:
Format|Cells|Alignment tab|shrink to fit
And you don't have to "hard code" the font size.

bmelt wrote:

How to disable displaying ### instead of number in a narrow column?

--

Dave Peterson

In Stingray Grid, if column is narrower then a value displayed, it is
possible to show ellipsis, like 123... or 123###. It is possible to turn this
feature on or off. It is more convenient to see a part of value than ###
instead of value. I expected it is possible at least turn off this feature in
Excel. From all answers, it sounds like it is not implemented in Excel.
Thanks everybody for your answers.

Regards,
Boris

"bmelt" wrote:

How to disable displaying ### instead of number in a narrow column?

Quicken has this feature too, that it will display as much as the number as
possible, followed by an ellipsis. Excel does not. You would have to use
formatting, and If statement or program a macro to do the same thing.

Regards,
Fred.

"bmelt" wrote in message
...
In Stingray Grid, if column is narrower then a value displayed, it is
possible to show ellipsis, like 123... or 123###. It is possible to turn
this
feature on or off. It is more convenient to see a part of value than ###
instead of value. I expected it is possible at least turn off this feature
in
Excel. From all answers, it sounds like it is not implemented in Excel.
Thanks everybody for your answers.

Regards,
Boris

"bmelt" wrote:

How to disable displaying ### instead of number in a narrow column?

The closest thing you can do in excel is to keep the number formatted as
general.

If the number is large enough and you start shrinking the column width, you'll
see the number displayed in scientific notation.

I'd rather change the font size or widen the column.

bmelt wrote:

In Stingray Grid, if column is narrower then a value displayed, it is
possible to show ellipsis, like 123... or 123###. It is possible to turn this
feature on or off. It is more convenient to see a part of value than ###
instead of value. I expected it is possible at least turn off this feature in
Excel. From all answers, it sounds like it is not implemented in Excel.
Thanks everybody for your answers.

Regards,
Boris

"bmelt" wrote:

How to disable displaying ### instead of number in a narrow column?

--

Dave Peterson