My first question; I hope it's not to difficult

[markjohnson]

Hello all

I am creating a spreadsheet and I need to key figures in the format of betting odds ie similar to fractions 4/1 for example.

I have used three cells for each set of odds, so in the example above 4 would be entered in one cell, the cell to the right has already got a forward slash and the cell to the right of that would have the 1 entered in.

I have set the formats of the cells so that(using the 4/1 as an example) the 4 will display on the right hand side of its cell and the 1 will display on the left hand side of its cell.

The problem I have is that they are to near to the sides of there respective cells and if I set the format so the numbers are in middle of their cells they are to far away from their sides.

My question is: Is there a way that allows you to set the numbers to be near which ever side you want and lets you decide exactly how far that number is away from the side.

I hope the above makes sense and if you have read this far thanks for reading.

regards
Mark

 

[VoG]

Hi. This doesn't directly answer your question but you can press ALT + 1 and select Fraction to display in a cell as below

Excel Workbook
	A
1	1/4
Sheet6

 

[AlphaFrog]

Indenting Cell Contents

To set the indent to be used in a cell, follow these steps:

1. Select the cells you want to format.
2. Choose Cells from the Format menu. Excel displays the Format Cells dialog box.
3. Make sure the Alignment tab is selected. (Click here to see a related figure.)
4. In the Horizontal drop-down list, choose Left (Indent). If you are using Excel 2002 or 2003, you can also choose Right (Indent).
5. Using the Indent control, specify the number of characters by which the cell contents should be indented from either the left or right side of the cell. You can pick any whole number between 0 and 15.
6. Click on OK

 

[markjohnson]

Thanks for your prompt reply VoG

The problem is that the odds would be best split over three cells as I described so as to make it easy for people to enter their odds.

thanks again

Mark

 

[markjohnson]

Wow this forum is great

That is exactly what I am after AlfaFrog.

Thank you very much

Mark