You're welcome!

--
Biff
Microsoft Excel MVP


"Scoober" wrote in message
...
Thanks Biff - that's worked a treat.

"T. Valko" wrote:

Maybe this:

Select the cell with the formula and the cell in the next column to the
right.
Goto the menu FormatCellsAlignmentHorizontalCenter across
selectionOK

As a *last resort*:
Select the cell with the formula and the cell in the next column to the
right.
Goto the menu FormatCellsAlignmentText ControlMerge cellsOK

Merging cells almost always causes unforeseen problems! Use this only as
a
last resort!

--
Biff
Microsoft Excel MVP


"Scoober" wrote in message
...
Hi Guys,

Sorry I did'nt explain myself very well.

Due to printing restraints I cannot stretch the cell any further, I
need
to
find a way to combine the ajasent cell to make one big cell to contain
the
answer.

Cheers Scott

"T. Valko" wrote:

Try widening the column.

--
Biff
Microsoft Excel MVP


"Scoober" wrote in message
...
How can i connect two row boxes togther to accept a particularly
large
answer

i.e. 100 x 1000000= 100000000

the '100,000,000' does not fit into one box and i get the #### sign
instead.

Cheers in adavnce