fraction

I think this is a formatting question ( or could be something else and I'm just not seeing it). I'd like to display data as 1/x. So the numerator is always 1 and the denominator changes. For example: 200/ 1000 = 1/5 2/5 = 1/10 330,000/330,000,000 = 1/1,000 403,000/330,000,000 = 1/819 Thank...

How do I display a number as a fraction of "1/something". At the same time I need to use the cell value in another calulation, so it needs to be formatted as some type of number (not a string). For example 0.666666667 to be displayed as 1/1.5.

Hey everyone, I want to format a decimal/fraction as a number of months. For example, I'd like to enter "=1/12" into a cell and have it show "1 month," or enter "=1.5/12" and have it show "1.5 months." Is this possible? Thanks!

Hello, This seems like a simple cell format issue but everything I have tried has not worked for me. I am using Office 365, I have 6 cells merged that display the result of an Index/match formula. This cell is formatted as a fraction but will only display a decimal number. I would like it to...

I am looking for a way to divide a fraction in one cell and put the percentage of that fraction into the next cell. Example: B2- 36/164 C2- Percentage from B2 (36/164 = 21.95%) Any help is greatly appreciated. Thanks.

Hi I formatted a group of cells to Number-->Fraction. The entered 1/2, 1/3, 10/12 and I got these number 1/2,1/3, and 5/6 in the right hand side of these cells (so far so good) but when i typed 10/11 or 11/12 , I got 1 in the middle of the cell? Why is that? Thank you.

I've only just found out in Microsoft Word how to type a fraction in the "normal" way, that is with the digits one above the other - if .5 is wanted as a fraction, type 1 followed by / followed by 2. Then press the space bar. The 1/2 changes to 1 over 2.(can't show it here!) I have been looking...

I've had this happen a couple of times now in Excel, where I'm subtracting or adding numbers and the results are not always the same, they're off by a tiny fraction. Am I doing something wrong here? https://www.dropbox.com/s/mqqay9nonl1tzn1/different%20results%2C%20same%20calculation.xlsx?dl=0

Hi everyone! I'm new to this forum so i'm hoping you guys can help me out. I'm trying to make a form that will be able to convert a measurement that is in carpenters form to a normal FT'In' Fraction Format. Ex. 9'6 1/2" is 09-06-08 the front 09-XX-XX stands for Ft, XX-06-XX stands for In...

I have a cell (A1) with a decimal value of 0.34375 in an adjacent cell (B1) which is equal to (A1) but is formatted as a fraction function with two digits to give a fraction of 11/32. Is there any way I can convert the fraction into two different cells (C1) and (D1) one for the numerator (C1)...

This is a slightly weird questions, but I need a decimal converted to a fraction a certain way, similar to the fractional number formatting. I'm guessing this will have to be done in VBA Here's an example of what I'm looking to do: I have a cell that is always rounded to the nearest 0.5, I...

Hi there, Not sure if the title of this question explains it very well... I have members of staff who work 'fractions' (which are actually decimals, but never mind, HR). I need to identify which fraction they work on a particular date. Some work multiple fractions simultaneously. I need a...

Hi guys, I'm having this weird issue in my spreadsheet. I have columns populated with fractions but in excel they are not yet selected as fractions (They are "general"). When I select them and change the data type to fraction, it says its a fraction but there is no change. When I individually...

I have two cells for entering in integer values for anumerator and denominator to be used in a spreadsheet for adding Feet, Inches,and Fraction of an Inch for two or multiple tape measure measurements or steelrule measurements.The numerator and denominator determine the value of the fraction of...

Hello, I am attempting to extract both the numerator and denominator of a fraction into separate individual cells. For example, a fraction of 209/69, I am seeking your assistance in a formula that can have the 209 and 69 in two separate cells. The fraction varies from one digit in the...

Using Excel 2010. I am attempting to display numbers as fractions in a message box. Sub HowToDisplayFractionsInMsgBox() Dim sngInput As Single sngInput = 0.75 'Selection.NumberFormat = "# ??/??" works to format a cell (and what VBA records) '="Fraction is: " &...

Hi all! I currently have two columns, each with fractions in them. They are visual acuities for the right eye and the left eye (the fraction that shows how good someone can see in each eye...e.g., 20/20, 20/10, etc.). I am trying to find a way to enter the maximum between the two cells into a...

I'm having some rounding issues with fractions. Here is what excel is calculating: -5/16 + 5/7 = 2/5 I'm looking for the answer 45/112 Also, for the value 24.666667 excel is showing 24 2/3. I would like this to show 74/3.

Hello, I have been trying to change fractions to decimals in one click without adding a colum. Just automatically change the values. Is this has to be with VBA? I have an exported file from solidworks and it shows the values as 3/16" , 3/8" , 40 1/2", 55 1/2" First I look for the " to delete...

<tbody> A B 1 0 0/1 2 1 1/2 3 1 2/3 4 0 2/4 5 1 3/5 6 0 3/6 </tbody> See above chart. In column A, I will have either 0 or 1 entered manually. For column B, I want to create a formula that is basically SUM/COUNT. So for example cell B6 is something like...