If the fractions are all found in Column A, you can format this
column for fractions. Right click the A at the top of the column to
highlight the entire column and open a context menu. Select Format
Cells. You will find 'Fraction' near the bottom of the Category list.
Click it, and then click OK to close the Formating window. You should
now be able to write fractions in Col. A.
One warning: Calc reduces fractions. So, 5/8, 10/16, and 20/32
all appear as 5/8.
Dan
On Monday June 04 2007 11:30 am, 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]
