Ask Experts Questions for FREE Help !
Ask
    Jimbos's Avatar
    Jimbos Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jul 22, 2008, 08:08 PM
    Rounding fractions
    My spreadsheet displays fractions in 64ths. Ex. 53/64 th. Question: How do I round and display this number to the nearest 1/16th? In this case 53/64 would round to 13/16 ths?
    jjwoodhull's Avatar
    jjwoodhull Posts: 1,378, Reputation: 239
    Ultra Member
    		  
    #2

    Jul 22, 2008, 09:32 PM
    53/64 is equal to 13.25/16 - so yes, if you rounded the number it would be 13/16
    smearcase's Avatar
    smearcase Posts: 2,392, Reputation: 316
    Ultra Member
    		  
    #3

    Jul 23, 2008, 01:56 AM
    The fraction (in 64ths) times 16 or
    (53 times 16) divided by 64
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #4

    Jul 23, 2008, 03:37 AM
    This is actually simpler, it's a FORMATTING question.

    • Click on the cell that has your 64ths showing
    • Press Ctrl+1 to open the Format Cell dialog box
    • On the Number tab, click Fraction for the category
    • Under Type select As sixteenths (8/16)
    • Click OK

    All done! This method preserves the original data, too, not doing any math on it.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Pre Cal : Fractions with Fractions as exponents [ 4 Answers ]

Can someone explain to me how to solve this equation: (4/9)-1/2* *Exponent ??

Rounding numbers [ 2 Answers ]

What is 12.17556 to the nearest ten-thousandth?

Rounding Down [ 2 Answers ]

I have an extremely basic spreadsheet that I need to stop rounding and just look at numbers as having two decimal places. I'm taking a currency gross and multiplying by 3% then subtracting the 3% from the gross My problem comes in when Excel looks at the number as having more than one...

Stop Excel from Rounding [ 1 Answers ]

I have created a Timesheet spreadsheet, in Excel, that calulates the amount of time between to manually entered times. This is the formula I am using =IF((OR(D8="";B8=""));0;IF((D8<B8);((D8-B8)*24)+24;(D8-B8)*24)) The formula works very well and does return the corrent amount of elapsed...

Excel rounding [ 1 Answers ]

ELATHAM How do I keep Excel from Rounding off. When it rounds off it makes my final totals wrong. My figures need to balance right to the penny. Thank you, Estrella

View more questions Search