Search results
Results From The WOW.Com Content Network
In C1 use formula =SUBSTITUTE (A1," "," ") (make sure that first " " is two spaces and the second is one) and ENTER. 2. Copy the entire column and paste back Special, Values only. 3. Now, Highlight Column C then go to Text To Columns, Next, Next, Finish. 4. in D1 enter formula =FIXED (D1) and copy it down.
The formula is simple enough of itself BUT I am struggling to apply it because the fractional odds are in presented in one cell like thus 7/2. I need to convert the 7/2 to equal 4.50 (7 divide 2 +1) but need a formula that will find the figures either side of the forward slash. Any help much appreciated
Forum Guru Join Date 02-27-2016 Location Vietnam MS-Off Ver 2021 Posts 6,122
Re: Convert Feet and Inches (Fractions) to Decimal Feet Administrative Note: Welcome to the forum. We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the ...
Select the cells you want to format. On the Format menu, click Cells. On the Number tab, click Fraction in the Category list. In the Type box, click the fraction format type you want to use: Single-digit fractions This format displays 123.456 as 123 1/2, rounding to the nearest single-digit fraction value.
Re: Convert decimal to 1/16ths. Based on your last post in this thread, its apparent that you are satisfied with the solution (s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time. Select Thread Tools-> Mark thread as Solved.
Re: Having trouble converting fractions to decimals. Try this, it's a bit of a cheat but seems to work. Open your file. Click Tools. Click Options. Look for the Transition tab, click the Transition check box, and then click OK. Next select your complete range of cells, E2:E1063. Next select Find & Replace and replace the double quote with nothing.
Decimals to Fractions. Enter the decimal number in the cell (ex. A1) right click on that cell, next click on Format Cells, next click on the Number Tab, next click on Fraction and under Type click on: Up to one digit (1/4) or 2 digits, etc; etc and then click OK. The Decimal number will convert to a Fraction. Register To Reply.
Would someone help me convert a fraction to a decimal number in a separate column. We sell ad sizes that are either: We sell ads in a monthly magazine. We sell ad sizes that are either: Full or full = 1 1/2 = 0.5 1/4 = 0.25 1/8 = 0.125 Out or out = 0 What I would like to know is how
A running decimal total for the dimensions added is calculated. I am converting this running decimal dimension total back to the FIF Format. However, I want the fraction (decimal or mantissa portion of the RT dimension) to be in sixteens and have the lowest common denominator. For example: 4/16 would be represented as 1/4, 2/16 as 1/8 etc.