How to stop ## showing when cell contents too wide

[Roger on Excel]

sI have narrow cells in which i have formulas which return a month name when
certain criteria are matched

When the formulas return a true result, the month name shows, but is too
wide for the narrow cell and displays as ##

Is there a way to make the contents display fully. I dont mind if the cell
answer covers the result from the next cell as there will always be blank
results next to the cell.

Can anyone help?

 

[JLGWhiz]

Format>Column>Width and set column to wider setting.

 

[JLGWhiz]

save the file after you change the setting so it will be there when you open
the file again.

 

[JLGWhiz]

You can also set the column to autofit by selecting the column, or even a
portion of it, and then Format>Column>AutofitSelection then save the file.

 

[Roger on Excel]

Hi,

Thanks, but,

Unfotunately i dont want to make the cell wider to make it fit as the
formatting of the rest of the sheet will be affected adversely.

Roger

 

[Rick Rothstein]

Another suggestion that may work out for you. Select the cell range you want
this functionality on (or select the whole column), click Format/Cells on
the menu bar, click the Alignment tab on the dialog box that comes up, put a
check mark in the CheckBox with the caption "Shrink to fit" and then click
OK. If your text is not too much longer than the column's width, it may
still be readable when shrunken.