# computers

posted by Larry King

Dear Sir,
thanks very much for your the very detail instruction which I am still working on it.
I need some help in using Microsoft Excel to format rational number in the form a/b( not in reduced form :eg. 3/6 but Excel will return value either in reduced form 1/2 or .5).
What I intend to generate from the three columns of excel ( first column 'a' denotes the variable stands for numerator of fraction a/b and second column denoting denominator b)to get all the equivalent fraction of 1/2 ( eg.2/4,3/6,4/8.......) putting in the third column.
Thanks
Larry King

1. Writeacher

If you mean how to get a column or row to keep exactly what you type, not to convert it to something else (such as a reduced fraction or decimal), here's one way:

1. Highlight the column by clicking on the letter across the top.
2. Click on Format and then Cells.
3. Click on Text and then OK.

From then on, everything you type in that column will stay exactly as you typed it in the first place.

To do the same thing with rows, step 1 includes highlighting the row by clicking at the left on the number of the row you want.

2. Dr Russ

A short cut to get a number to appear as text is to include a ' in front of the number as you type so

'1/2 appears as 1/2

1/2 often appears as 39845 as Excel interprets it is a date

3. Larry King

DEar Writeacher/ Dr Russ,
Thanks very much for the answer but I have made a typo error in my question; it should be "Not in reduced form of the fraction that I wish to get but excel also always gives a/b in reduced form or in decimal form which is not what I wanted.
I am aware of the method given by Dr. Russ. Thanks. but what I wanted to make is a bit different; I intend to generatea/b by dragging down the first two rows from the three columns of excel ( first column 'a' denotes the variable stands for numerator of fraction a/b and second column denoting denominator b)to get all the equivalent fraction of 1/2 ( eg.2/4,3/6,4/8.......) putting in the third column.
Thanks
Larry King
eg.
a b a/b
1 2
2 4
3 6
4 8
5 10
6 12
7 14
8 16
9 18
10 20
11 22
12 24

Cannot get a/b using either of the two methods suggested.
Thanks
Larry King

4. Larry King

DEar Writeacher/ Dr Russ,
Thanks very much for the answer but I have made a typo error in my question; it should be "Not in reduced form of the fraction that I wish to get but excel also always gives a/b in reduced form or in decimal form which is not what I wanted.
I am aware of the method given by Dr. Russ. Thanks. but what I wanted to make is a bit different; I intend to generate a/b by dragging down the first two rows from the three columns of excel ( first column 'a' denotes the variable stands for numerator of fraction a/b and second column denoting denominator b)to get all the equivalent fraction of 1/2 ( eg.2/4,3/6,4/8.......) putting in the third column.
Thanks
Larry King
eg.
a b a/b
1 2 1/2
2 4 2/4
3 6 3/6
4 8 4/8
5 10 5/10
6
7
8
9
10

5. Larry King

Dear Writeacher,
Below is what I wish to get : following your suggestion I can get first two columns but getting the third which it should look like what is found in the 4th column is my difficulty. by mere typing in text format is not the problem. what i wish to get is to use the variable a and b and employing excel capability to get all the fraction by dragging down a/b. but i got not fraction,instead i get cells addresses. I hope you got I wanted.
thanks
Larry King
a b
1 2 =A2/C3 1/2
2 4 =A2/C4 2/4
3 6 =A2/C5 3/6
4 8 =A2/C6 4/8
5 10 =A2/C7 5/10
6 12 =A2/C8 6/12
7 14 =A2/C9 7/14

7

6. Larry King

a b
1 2 =A2/C3 1/2
2 4 =A2/C4 2/4
3 6 =A2/C5 3/6
4 8 =A2/C6 4/8
5 10 =A2/C7 5/10
6 12 =A2/C8 6/12
7 14 =A2/C9 7/14

Dear Writeacher,
Below is what I wish to get : following your suggestion I can get first two columns but getting the third which it should look like what is found in the 4th column is my difficulty. by mere typing in text format is not the problem. what i wish to get is to use the variable a and b and employing excel capability to get all the fraction by dragging down a/b. but i got not fraction,instead i get cells addresses. I hope you got I wanted.
thanks
Larry King

## Similar Questions

how can you tell which form of a rational number is most appropriate in a given situation?
2. ### BCIS

You need to use the help section in your Excel program (press the F1 key and then use the search feature). If you need additional information about Excel, you can use your textbook or go to http://support.microsoft.com/search/, select …
3. ### Computers

In reference to Microsoft Excel.... Explain what a compound document is, and why might you need to create a compound document. What are some examples of potential compound documents
4. ### Math 111 (College Algebra)

Rational number or irrational? And why? I have been challenged in my college algebra class to determine whether or not .12122122212222122221222221... (continuing forever)is a rational number or not. I need to prove one way or the other.
5. ### english grammar

please help me if my letter is correct in the grammar. kindly help me to make a good letter. march,21,2011 subject:sales commission to: THE MANAGER DEAR SIR, I am writing to you due to next month will be my annul vacation and,I would …
6. ### Microsoft Excel

The order of precedence is very important when building formulas in Excel. Which of the following formulas will produce 778 as the result?
7. ### math

A retailer planned to buy some computers form a wholesaler for a total of Shillings 1,800,000. Before the retailer could buy the computers the price per unit was reduced by shillings 4,000. This reduction in price enabled the retailer …
8. ### math

A retailer planned to buy some computers form a wholesaler for a total of Shillings 1,800,000. Before the retailer could buy the computers the price per unit was reduced by shillings 4,000. This reduction in price enabled the retailer …
9. ### math

A retailer planned to buy some computers form a wholesaler for a total of shilling 1,800,000. Before the retailer could buy the computers the price per unit was reduced by shilling 4,000. This reduction in price enabled the retailer …
10. ### writting skills

For the greeting in a business letter when you don't know the name of the person who will be reading it, which of the following is least likely to conform to present-day usage?

More Similar Questions