Thanks Tony,
Appreciate your patience.
Vince
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
