Example:
1.25 is in cell A1. This number will often be buried in a longer part number that may look like ELL-1.25-S40.
I would like to use a formula in cell A2 to display the fractional equivalent (1-1/4).
I hope my simple questions don't expose my Excel adolescence. Eventually I'll be providing the solutions instead of asking for them, I promise!
Hi all
I am using excel rtd links to populate some cells.
I want to convert the numbers which are in fractions to decimals.
eg.
98.01+ -> 98.046875 where 01+ means 1.5 / 32
98.02 -> 98.0625 where 02 mean 2 / 32
Is there any available formulas?
Ok I am using CONCATENATE in the following way "=CONCATENATE(AB96,"-",AD96)"
cell AB96 is a measurement in feet and AD96 is a measurement in inches...therefore if AB96 was 8 and AD96 was 1 1/2 the CONCATENATE cell reads 8-1.5
However I want the CONCATENATE cell to read 8-1 1/2, not 8-1.5...changing the format of the cell to fraction doesn't help either...any help?
I know that if I enter =3/4 in a cell it will give me .75 but is there is formula to convert fractions into decimals or is this the best way to do it? I was also wondering if there is some way to convert the decimal amount to a fraction
for measurement conversions I know that
=B3*25.4 will convert a decimal to mm and so will the formula =CONVERT(E4,"in","mm")
and to convert mm to a decimal a few formula that work are
=CONVERT(H3,"mm","in")
=MROUND(H4/25.4, 1/8)
=H5/25.4
=INT(H6/25.39999918*8)/8
But is there a way to convert a fraction to the decimal and is there a way to convert mm to a fraction instead of the decimal equivalent of the fraction?
or maybe a formula to convert mm to inches but instead of the result being in decimal format it would be in fraction format?
Hi Folks, I'm seeking code to convert the following futures data quoted in fractions (after the apostrophe) to decimal (quotes for treasury notes and bonds)?
Data in fraction-format
125'08.5
125'14.0
124'17.5
....needs to be converted to decimal-format:
125.265625
125.4375
124.546875
Where '08.5 = 8.5/32 = 0.265625
'14.0 = 14.0/32 = 0.4375
'17.5 = 17.5/32 = 0.546875
ie number after apostrophe is the numerator-value in the format xx.x, denominator value=32):
Thanks in advance for your help and the great forum.
I have a worksheet housing long decimal numbers as a specific lengths. I need to convert the decimals to fractions.
Example (in inches):
00002.8346
00003.1496
00003.1496
00003.3464
00003.3464
00003.3464
I need to convert each of these to fractions to represent their size in inches. I need the formatted output to be specific though. I need it to read as
Example:
00001.25 = 1-1/4" (dash included)
Is there a script that can do that or a specific function maybe? I'm stumped!
Why does Excel 2007 change SOME of my cell entries from the decimals I enter (and want to keep) to fractions? In one column I have a mixture of results, all with the same value (9.5 and 9 1/2). It is not a column-width problem.
This is involving 3 cells Exp: B17=5.5, E17=100. I need to show this as a fraction in cell E21 as 5.5/100 without being rounded up to 6. Is this possible? As a result of the many calculations it shows whether the testing is accepted or FAILED.
If it FAILED how can I show the word FAILED in red?
I have a macro for importing data from an XML file and converting it to CSV (after some manipulation, amputation etc.). One field represents the odds of something happening. This means the field contains mostly integers and some fractions. I want all fractions to display (and save in .csv) as decimals w/2 sig figs. In other words, if the field right now displays as 3/5 I want it to convert to 0.60.
I have indicated that the column should be Numeric. I thought this would make 3/5 turn into 0.60 but it does not, as nothing changes. I figured out that it only changes if I DOUBLE CLICK on the fractional value (??!?) after setting the column as a Number. Note that I change nothing in the cell, just double click and then move away.
How do I, within a macro, tell excel I want junk like 1/5 to render as 0.20?
using a formula to combine multiple cells. one of the cells has a fraction 5
1/4 . the results of the formula from the combined cells is converting the 5
1/4 to 5.25 how do I get the result of the formula to retain the 5 1/4
fraction. I have tried formating the cell but that dosen't seem to work.
Using excel 2002
