+ Reply to Thread
Results 1 to 7 of 7

How do I center all my fractions?

  1. #1
    Registered User
    Join Date
    04-19-2014
    Location
    France
    MS-Off Ver
    Excel 2013
    Posts
    25

    Question How do I center all my fractions?

    Hello.

    How do I make all my fractions align the same way?

    Here is a screenshot of my problem: http://oi59.tinypic.com/28vzi8x.jpg

    As you can see all my fractions are not aligned the same way: the 1s are aligned to the left, while the other fractions are (almost) aligned to the center.

    When I select all my fractions and click on "Align Left" or "Center" or "Align Right" it doesn't fix the problem...

    Thanks in advance for your answers.
    Last edited by Terminatrix; 06-12-2014 at 04:10 PM.

  2. #2
    Registered User
    Join Date
    06-11-2014
    Posts
    4

    Re: How do I center all my fractions?

    I could nt open the link but athe reason might be blanks , you can use trim function then align.

  3. #3
    Registered User
    Join Date
    04-19-2014
    Location
    France
    MS-Off Ver
    Excel 2013
    Posts
    25

    Re: How do I center all my fractions?

    I don't understand... What "blancks"? And what is the "trim function"?

    If you can't see my screenshot, try this one: http://img11.hostingpics.net/pics/965882EXCEL03.png

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,584

    Re: How do I center all my fractions?

    A sample spreadsheet, rather than a picture, might be more useful for helping us help you.

    1st thing I notice is the little green triangles. What type of data are these -- "numbers stored as text" or are they actual numbers? If they are text strings, is it necessary for them to stay as text strings, or can we consider converting to numbers, or must they be converted to numbers?

    Basic controls for aligning data in cells are in the alignment group on the home tab: http://office.microsoft.com/en-us/ex...987.aspx?CTT=1
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  5. #5
    Registered User
    Join Date
    04-19-2014
    Location
    France
    MS-Off Ver
    Excel 2013
    Posts
    25

    Re: How do I center all my fractions?

    Okay here is a sample spreadsheet with my problem:

    fractions.xlsx

    As you can see, I inserted a formula on some cells, and then chose the format "fraction" to display my numbers as fractions. But they are not aligned with the 1s.

  6. #6
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,584

    Re: How do I center all my fractions?

    Can you describe the output you want?

    Based on the current number format ("# ??/??"), Excel is formatted for mixed numbers (a b/c). The # tells Excel to only display the whole number portion if it is not 0 (0 will not be displayed). The ? tell Excel to not display insignificant 0's, but to keep the space. So, this number format will keep the whole number portion of each value aligned, and will keep the fraction part aligned on the /. So, one could argue that Excel is aligning the values exactly as you have told it to. (You should be able to see this if you use 0's "0 00/00" so that it displays 0's for each placeholder).

    Perhaps you simply want each value centered? A number format using all # might be more ("# ##/##") appropriate for what you want.

    If not, I might suggest a review of this (http://office.microsoft.com/en-us/ex...372.aspx?CTT=1) for instructions on the different parts of number formatting. A better explanation of how you want the values aligned would also be needed.

  7. #7
    Registered User
    Join Date
    04-19-2014
    Location
    France
    MS-Off Ver
    Excel 2013
    Posts
    25

    Re: How do I center all my fractions?

    Thank you MrShorty, your "# ##/##" format worked =)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Problem with fractions rounding, and center justification.
    By Garren1013 in forum Excel General
    Replies: 4
    Last Post: 01-13-2010, 10:43 AM
  2. My Fractions
    By OfficeBitty in forum Excel General
    Replies: 20
    Last Post: 12-14-2006, 02:27 PM
  3. Converting Decimal Fractions to Fractions of a Specified Number
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-29-2005, 11:09 AM
  4. fractions help
    By splitsixty in forum Excel General
    Replies: 6
    Last Post: 08-02-2005, 06:03 PM
  5. Replies: 1
    Last Post: 03-29-2005, 08:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1