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

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?

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

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.

" wrote:

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?

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

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).


" wrote:

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?

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

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


"JMB" wrote in message
...
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.

" wrote:

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?

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

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

"JMB" wrote in message
...
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).


" wrote:

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?