- Convert decimal to inch & fraction
- Formula for converting decimal to inch & fraction
- Formula for converting decimal to inch & fraction
- Convert mm to inch
- Convert Decimal to Fraction
- Convert decimals to feet / inches in excel
- Convert mm to inches
- Converting pixels to inches
- convert decimals to only 2 places for whole range
- Convert decimal to time
- Converting from feet, inches and fractions to inches and decimal p
- Convert Decimals To Feet & Inches
- Formula to convert decimal ft to fractional ft
- Convert fractions to decimals and decimal to fraction
- Convert decimals to fractions
- Feet, inches and fractions to inches and dec.....reposting for Pet
- Converting decimals to fraction...
- Convert mm to fractional inches
- Decimals to fraction
- Decimal to fraction conversion?
- How do I convert decimal to feet and inches
- Convert Decimal to 24-bit Binary
- Converting decimals to 1/16ths
- VBA macro to convert decimal to hex and back

I am using Excel 2000.

Thank you for your help.

I am using Excel 2000.

Thank you for your help.

the below formula works great as long as the mm are positive. How do I change it so that it works whether positive or negative?

I use this code

VB:It comes out like 89/8, but i want something like 11 1/8Dim lngTest As Long Dim dblResult As Double lngTest = 0 Do lngTest = lngTest + 1 dblResult = lngTest / dblDecimal Loop Until Int(dblResult) - dblResult = 0 LongFraction = lngTest & "/" & Int(dblResult) End FunctionIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Can please anyone help me to solve this???

Thank you!!

The trouble is that I want it in fractions that correspond with a ruler.

Hence, I need 1555 mm to be 61 1/4" not 61 2/9"

I need all measurements to round off to the nearest 1/8

Does the width in pixels depend on the resolution of the screen? If so, is there some way to convert the width is pixels to a width in some constant unit (inches, points, centimeters, etc.)?

If the width in pixels isn't dependent on the resolution, where does it come from, and how can I convert it to inches?

Any help would be appreciated.

I'm currently having following code to convert decimals to 2 digits.

but here I got to select the range ( for example Q2 to Q1500), I would like to tweek this code may with help of a looping so that I would convert all the data located in Q column not restricting to specific range .. code is as follows :

Sub sumtest()

Dim myrange As Range

Dim allData As Range

Set allData = Range("Q2:Q1500")

For Each myrange In allData

With myrange

If IsNumeric(myrange) Then myrange.Value = ((100 * Application.WorksheetFunction.Sum(myrange.Cells) + 0.01) 1) / 100

On Error Resume Next

End With

Next myrange

End Sub

Thank you all

We have a program that exports a table from Auto-cad to Excel, using a

program called TableBuilder. It exports using feet, inches and fractions eg

6'-5 1/2" or 4'-0".

I'm looking for a way to convert this to inches and decimal points and all

the -, ', " removed.

for example 6'-5 1/2" will be 77.5 and 4'-0" will be 48

Any ideas? It's a huge spreadsheet and doing each conversion individually

will drive me nuts.

Cheers in advance

Dee

Right now, the way i have it, it spans across (7) different cells to get the results i desire. Is there a way i can make this shorter?

A11 – This is where the decimal value of a number is inputted.

B11 – This is the final display after running A11 through the formulas below

Here are my formulas:

B11 =IF(H11>=15.5,(H11+F11)/100+C11,(((H11/10000)+(F11/100)+(+C11))))

C11 =ROUNDDOWN(A11,0)

D11 =SUM(A11-C11)

E11 =IF(D11>=0.997395,D11+C11,D11*12)

F11 =ROUNDDOWN(E11,0)

G11 =SUM(E11-F11)

H11 =SUM(16*G11)

What this is doing is sort of hard to explain. Here at work, we run Hewlett Packard calculators to help work with lengths. Well there is a special way we can read Feet-Inch-Fractions on these calculators (using the whole number and 4 decimal places). It does all types of calculations with this number format but it first has to convert it to decimal format, do the math, then back to the Feet-Inch-Fraction format so we can read it again.

What this formula above does is convert the decimal format to the Feet-Inch-Fraction format.

The whole reason why im trying to get this in excel is because im trying to make some work sheets that do the same type thing on a bigger scale. I already have the conversion of the Feet-Inch-Fraction format to decimal format figured out but I cant get excel to convert back the other way without having a huge formula.

Did any of that make sense??

Also, there needs to be a way to reduce the fractions down to the smallest value.

Examples: 4/16" should not reduce to 2/8" but rather 1/4".

8/16" should not reduce to 4/16" or 2/4" but rather 1/2"

I will only need values down to 1/16" of an inch. No need to go lower.

Any ideas?

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?

convertDecimal2Fraction() ' this VBA macro will convert a decimal value on an MS Excel spreadsheet ' to a fraction in the cell immediately to the right of the active cell. ' It uses the concept of continued fractions to calculate an approximate ' fraction for your decimal. Useful resources about the continued fractions ' concept (that i shamelessly used) are available at : ' [url]http://www.mcs.surrey.ac.uk/Personal/R.Knott/Fibonacci/cfINTRO.html[/url] and ' [url]http://homepage.smc.edu/kennedy_john/CONFRAC.PDF[/url] Dim x As Double Dim z As Double Dim fraDen As Double Dim fraNum As Double Dim preDen As Double Dim preNum As Double Dim counter x = ActiveCell.Value 'make sure the decimal value you want converted is highlighted z = x preDen = 0 fraDen = 1 counter = 0 Do z = (1 / (z - Int(z))) scratchValue = fraDen fraDen = Int(z) * fraDen + preDen preDen = scratchValue fraNum = Int(x * fraDen + 0.5) counter = counter + 1 Loop Until (Abs((x - (fraNum / fraDen))) < 1E-20) Or (z = Int(z)) Or (counter = 594) ActiveCell.Offset(0, 1).Value = fraNum & "/" & fraDen End SubIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

No idea why it's not coming up.

My reply was as follows,

That would be amazing! The first cell this needs to applied to is D5 and the

same column D.

Thank you in advance

Dee

"Pete_UK" wrote:

> It will be a complex formula (almost finished), but to avoid problems

> with converting cell references can you tell me which is the first

> cell that this will apply to in your sheet, eg F2, and which column

> you want the formula to go into? Then I can give you the exact formula

> which you will be able to copy/paste into your sheet.

>

> Pete

>

> On Sep 17, 10:06 pm, Dee > wrote:

> > Morning,

> >

> > We have a program that exports a table from Auto-cad to Excel, using a

> > program called TableBuilder. It exports using feet, inches and fractions eg

> > 6'-5 1/2" or 4'-0".

> >

> > I'm looking for a way to convert this to inches and decimal points and all

> > the -, ', " removed.

> > for example 6'-5 1/2" will be 77.5 and 4'-0" will be 48

> >

> > Any ideas? It's a huge spreadsheet and doing each conversion individually

> > will drive me nuts.

> >

> > Cheers in advance

> >

> > Dee

>

>

>

Can anyone help me with a code for converting decimal number to a nearest 1/16 th fraction. For example converting number 2.1875 to 2 3/16 and so on...Also if it is 2.5 it should display 2 1/2...

Thanks in advance,

Sathish.

I have a column with measurements in millimeters and I want to convert them to proper fractional inches.

i.e. 29mm in one cell needs to be converts to 1 1/4.

As well as the above, I the fraction should be no smaller that 1/8. In other words I don't want 16ths or 32ths. Just 8ths, Quarters & halves. It should round to the nearest fraction.

I did look at some other posts but couldn't find the right solution.

Thanks

Can someone help me to convert decimals to fraction. I mean fixed fraction, only fraction of 8 and 16. So if the decimal is between 0,03125 and 0,09375

then 1/16, but if the decimal is between 0.09376 and 0,15625 then it showes 1/8. and so on. 3/16, 3/8.......

IF you can help me to write the script from the beginning of the script, include the start of the fraction test and the end of the script. I know it much to ask for, but I hope someone will help me

Rune

Without using VBA would be ideal, but if thats the path, then so be it.

Thanks yall!

- Jasen

formats. I need to convert 188.76 inches to feet and inches.