Hi Vince,
In that case, you want to use cell formatting to get what you want. Select a column by clicking on the letter heading at the top of the column, right-click a cell in that column and select 'format cells'. Choose 'fractions' from the list of pre-defined formats. Choose the second format code option if you'll want two-digit denominators like 3/16. Now you'll be able to enter 5/64 in any cell of that column and it will display as a fraction. Select the next column and format the cells as numbers with four decimal places. In that column enter the formula =a1, =a2 etc, given that your fractions are in column A. You can use 'edit / fill down' to avoid having to type each formula. This will give you the decimal equivalent of each fraction you enter in the first column.
tc

Vincent A Juliano wrote:
Anthony, et al.
I just reread what I sent out and it in no way indicated what I was looking for. Please color me dumb.

I have a table of conversion from fractions to decimals. I'm looking for a way to make a copy of this table and keep it in my computer as well as make copies to keep it in my basement shop so I can refer to it when using my numbered drills along with other small stuff such as wire cable. Tried to use a spread sheet but as I entered the fractions at first they were as I typed them , then they came out like decimals, after reentering them they came out as dates, i.e. 9/16 ===09/16/07. I don't know how to fix that . So I abandoned the spread sheet. .Now I'm looking for a way to set up a table to enter the fractions on one side and the decimals on the other but Using two sets of three columns. Anthony, I'm totally overwhelmed by what you sent and I have no idea of what you mean. I wish to thank you and the others for your help.
thanks again
Vince



Hi Vince,
This should get you started. Below are the first fifteen rows of columns A to E with formulae displayed. Enter the first two rows below, then use fill down to get as many fractional numbers as you would like in your chart. The result is below the formula list. Select all, copy and paste special with all checked except 'formulas'. Sort the data by column 'E'. Delete all the rows that evaluate to 1.0000.

1    /    1    =    =A1/C1
=IF(A1=C1;1;A1+1)    /    =IF(A2=1;C1+1;C1)    =    =A2/C2
=IF(A2=C2;1;A2+1)    /    =IF(A3=1;C2+1;C2)    =    =A3/C3
=IF(A3=C3;1;A3+1)    /    =IF(A4=1;C3+1;C3)    =    =A4/C4
=IF(A4=C4;1;A4+1)    /    =IF(A5=1;C4+1;C4)    =    =A5/C5
=IF(A5=C5;1;A5+1)    /    =IF(A6=1;C5+1;C5)    =    =A6/C6
=IF(A6=C6;1;A6+1)    /    =IF(A7=1;C6+1;C6)    =    =A7/C7
=IF(A7=C7;1;A7+1)    /    =IF(A8=1;C7+1;C7)    =    =A8/C8
=IF(A8=C8;1;A8+1)    /    =IF(A9=1;C8+1;C8)    =    =A9/C9
=IF(A9=C9;1;A9+1)    /    =IF(A10=1;C9+1;C9)    =    =A10/C10
=IF(A10=C10;1;A10+1)    /    =IF(A11=1;C10+1;C10)    =    =A11/C11
=IF(A11=C11;1;A11+1)    /    =IF(A12=1;C11+1;C11)    =    =A12/C12
=IF(A12=C12;1;A12+1)    /    =IF(A13=1;C12+1;C12)    =    =A13/C13
=IF(A13=C13;1;A13+1)    /    =IF(A14=1;C13+1;C13)    =    =A14/C14
=IF(A14=C14;1;A14+1)    /    =IF(A15=1;C14+1;C14)    =    =A15/C15


This is what it looks like before sorting.
1    /    1    =    1.00000
1    /    2    =    0.50000
2    /    2    =    1.00000
1    /    3    =    0.33333
2    /    3    =    0.66667
3    /    3    =    1.00000
1    /    4    =    0.25000
2    /    4    =    0.50000
3    /    4    =    0.75000
4    /    4    =    1.00000
1    /    5    =    0.20000
2    /    5    =    0.40000
3    /    5    =    0.60000
4    /    5    =    0.80000
5    /    5    =    1.00000

If you don't want every every denominator, you'll have to be more creative in the formulae.
tc


Vincent A Juliano wrote:
I'm having no luck using  a spread sheet.

In the tutorials where is there information to set up a table that will show the fraction and the corresponding decimal? I'd like to use six small columns for clarity.
Thank you

Vince

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]





---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to