How to format number and not return ######

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gavin_scott@thredbo.com.au - 12 Sep 2007 02:08 GMT

I have formatted a number as 0.00" C/Mtres" and it returns the result
of #### because the column is too narrow.
If I don't want to make the column wider or reduce the size of the
font how do I fix this?

Reply to this Message

JMB - 12 Sep 2007 04:44 GMT

Merge that cell with an adjacent one. Only other thing I can think of is to
change the formatting to something that fits in the cell.

> I have formatted a number as 0.00" C/Mtres" and it returns the result
> of #### because the column is too narrow.
> If I don't want to make the column wider or reduce the size of the
> font how do I fix this?

Reply to this Message

Rick Rothstein (MVP - VB) - 12 Sep 2007 09:00 GMT

That "change the formatting to something that fits in the cell" might be as
simple as selecting Format Cells, clicking the Alignment tab and placing a
checkmark in the "Shrink to fit" check box under the "Text control" section.

Rick

> Merge that cell with an adjacent one. Only other thing I can think of is
> to
[quoted text clipped - 4 lines]
>> If I don't want to make the column wider or reduce the size of the
>> font how do I fix this?

Reply to this Message

JMB - 12 Sep 2007 04:48 GMT

Although I should also mention I'm not a fan of using merged cells (except
occasionally for headers, but never for data). I've heard they can cause
other problems (particularly if you have macros that work with said data).

Reply to this Message

David Biddulph - 12 Sep 2007 09:35 GMT

Rather than merging, you may wish to centre the content of that cell across
a group of cells.

Signature

David Biddulph

> Although I should also mention I'm not a fan of using merged cells (except
> occasionally for headers, but never for data). I've heard they can cause
[quoted text clipped - 4 lines]
>> If I don't want to make the column wider or reduce the size of the
>> font how do I fix this?

Reply to this Message