[users] Creating a decimal/ fraction conversion table

2007-06-04 Thread Vincent A Juliano
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

Re: [users] Creating a decimal/ fraction conversion table

2007-06-04 Thread Anthony Chilco
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

Re: [users] Creating a decimal/ fraction conversion table

2007-06-04 Thread Vincent A Juliano
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

Re: [users] Creating a decimal/ fraction conversion table

2007-06-04 Thread Anthony Chilco
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

Re: [users] Creating a decimal/ fraction conversion table

2007-06-04 Thread Dan Lewis
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

Re: [users] Creating a decimal/ fraction conversion table

2007-06-04 Thread Vincent A Juliano
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