computers

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. 0
asked by Larry King
  1. 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.

    posted by Writeacher
  2. 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

    posted by Dr Russ
  3. 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.
    Please help!
    Thanks
    Larry King

    posted by Larry King
  4. 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

    posted by Larry King
  5. Dear Writeacher,
    thanks for the reply:
    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

    posted by Larry King
  6. 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,
    thanks for the reply:
    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

    posted by Larry King

Respond to this Question

First Name

Your Response

Similar Questions

  1. 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? (A. Dear Editor) B. Dear Mrs. Carleton C. Dear Mr.
  2. business

    You are writing to alumni of fraternity raising money for a scholarship. if you cannot personalize the letters, what would be the best salutation? A) Dear Brother B) Dear Sir C) Dear wealthy Alumnus D) Dear Alpha Kappa Psi Member
  3. business communication

    You are writing to alumni of a fraternity raising money for a scholarship. If you cannot personalize the letters, what would be the best salutation? (Points: 5) "Dear Brother" "Dear Sir" "Dear Wealthy Alumnus" "Dear Alpha Kappa
  4. ENGLISH

    dear sir i would like to know abstract noun for certain common nouns eg agent ,thief,pilgrim,glutton.
  5. Shakespear

    Read the exchange between Romeo and Nurse in Act II, scene iv of Romeo and Juliet. Romeo: Bid her devise Some means to come to shrift this afternoon; And there she shall at Friar Laurence’ cell, Be shriv’d and married. Here is
  6. Accounting

    Dear sir,Hi, My question is related to Accounting, would appreicaite if you could solve my question. Q. 1
  7. Pioneer Foods

    I need some ideas! Describe in detail for at least 3 subject areas how food history and Dutch oven cooking can be used for hands-on instruction and as an extension to in-class curriculum.
  8. 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, SIR,I AM WRITING YOU DUE TO NEXT WILL BE MY ANNUAL VACATION AND I WOULD
  9. English 2

    12. All of the following words describe Sir Lancelot Du Lake except a. loyal b. indirect c. strong d. clever B? 13. What is the most likely reason that Sir Lancelot doesn't initially fight the three Round Table knights at the end
  10. 9th grade

    what makes sir launcelot a hero? from the book title: the tale of sir launcelot du lake by: sir thomas malory translated by: keith baines

More Similar Questions