Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Large answers
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Large answers
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 FormatColumnAutofit Selection. BTW.............the "boxes" are known as cells. Gord Dibben MS Excel MVP On Sat, 6 Dec 2008 20:56:01 -0800, Scoober wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Large answers
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Large answers
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Large answers
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Large answers
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Large answers
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to get the answers from 3 conditions | Excel Worksheet Functions | |||
Please help me with answers | Excel Discussion (Misc queries) | |||
using formula with several possible answers | Excel Worksheet Functions | |||
Vlookup gives wrong answers when used in large data. Pls advise? | Excel Worksheet Functions | |||
Does anyone know the answers to | Links and Linking in Excel |