How to stop ## showing when cell contents too wide
 

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?

How to stop ## showing when cell contents too wide
 

FormatColumnWidth and set column to wider setting.

"Roger on Excel" wrote:

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?

How to stop ## showing when cell contents too wide
 

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

"Roger on Excel" wrote:

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?

How to stop ## showing when cell contents too wide
 

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

"Roger on Excel" wrote:

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?

How to stop ## showing when cell contents too wide
 

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

"JLGWhiz" wrote:

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

"Roger on Excel" wrote:

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?

How to stop ## showing when cell contents too wide
 

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.

--
Rick (MVP - Excel)


"Roger on Excel" wrote in message
...
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

"JLGWhiz" wrote:

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

"Roger on Excel" wrote:

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?