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]