Large answers

  • Thread starter Thread starter Scoober
  • Start date Start date
S

Scoober

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
 
Make the column wider.

Drag it wider by hovering the cursor over the right edge of the column
header and click-dragging the 2 headed plus sign to the right or go to
Format>Column>Autofit Selection.

BTW.............the "boxes" are known as cells.


Gord Dibben MS Excel MVP
 
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
 
Maybe this:

Select the cell with the formula and the cell in the next column to the
right.
Goto the menu Format>Cells>Alignment>Horizontal>Center across selection>OK

As a *last resort*:
Select the cell with the formula and the cell in the next column to the
right.
Goto the menu Format>Cells>Alignment>Text Control>Merge cells>OK

Merging cells almost always causes unforeseen problems! Use this only as a
last resort!
 
Thanks Biff - that's worked a treat.

T. Valko said:
Maybe this:

Select the cell with the formula and the cell in the next column to the
right.
Goto the menu Format>Cells>Alignment>Horizontal>Center across selection>OK

As a *last resort*:
Select the cell with the formula and the cell in the next column to the
right.
Goto the menu Format>Cells>Alignment>Text Control>Merge cells>OK

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