How do I get numbers to extend into unfilled cells like text

[patcha]

you know how if you type text into a cell if there is nothing in the
cells next to it it will overflow into those cells so that you can see
all of the text. Why dont numbers work the same way. Even if the
cells are empty I cannot get numbers to overflow into the open cells.
does anyone know what I have to do to get this to work? Merging the
cells is not an option, due to the formula im using.

 

[Malcolm Graham]

I do not know of any way to get the numbers to continue
into an adjacent (even empty) cell. You might try:

Format
Columns
Autofit

that might get the column to expand to display the longer
numbers.

Hope this helps.
MG