Free Microsoft Excel 2013 Quick Reference

convert cm to inches

Although the convert function is listed in excel 2002 help it is not
available from the insert formula command and it does't work in excel 2002.
s there a way to get it to work?
=CONVERT(A2,"cm","in") Returns NAME?


I am using the Width property of some cells to determine their width. This is returned in pixels.

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.

CAN YOU FORMAT A CELL TO CONVERT DECIMALS TO INCH & FRACTION OF INCH?

Change default measurements from cm to inches
Why can I not find this in Excel?

It is easy as pie to change in Word 2003.

Any time MS software installs in Canada, it defaults to centimeters.
Uh... Hello ... Microsoft ... 8.5x11 paper is the standard size for
paper - I want my margins in inches too !

Anyone know how to change this. I queried the help file in Excel - no
go.

I need to convert millimeters to inches.

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

I need to convert mm to inch fraction as read on a ruler to the nearest 1/8th

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?



CAN YOU FORMAT A CELL TO CONVERT DECIMALS TO INCH & FRACTION OF INCH?

Although the convert function is listed in excel 2002 help it is not
available from the insert formula command and it does't work in excel 2002.
s there a way to get it to work?
=CONVERT(A2,"cm","in") Returns NAME?

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

Hey Pete_uk,
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
>
>
>

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?

I need help shrinking down my formula to make it fit in one cell.

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??

Can you provide a formula to convert a decimal to an inch & fraction?
I am using Excel 2000.
Thank you for your help.

I've seen the other posts but they deal with smaller numbers or different
formats. I need to convert 188.76 inches to feet and inches.

Can you provide a formula to convert a decimal to an inch & fraction?
I am using Excel 2000.
Thank you for your help.

Can you format a cell to convert decimals to feet & inches
i.e. 10.250 to 10'-3"

Hi! I am working in excel 2003 and I need to convert feet and inches into decimal feet.
Example: 15'-10 5/8" to 15.88542

15'-10 5/8" will be in say, column B, and the conversion will be in say, column Q.

This formula will be copied all the way down the page.

Any thoughts on how to do this or can it even be done in this version?

Thanks for the help in advance.
hrg

I have size data given in millimeters and converting it into inches in 16ths
fraction format. How do I reduce resulting fractions to lowest term - I don't
want to see 8/16 but do want 1/2.

I have used the following formula to convert to inches,
=LEFT(D3,FIND("'",D3)-1)*12+VALUE(LEFT((RIGHT(D3,LEN(D3)-FIND("-",D3))),LEN(RIGHT(D3,LEN(D3)-FIND("-",D3)))-1))

But when I divide it by the conversion factor inches to meters I get errors
=(LEFT(D3,FIND("'",D3)-1)*12+VALUE(LEFT((RIGHT(D3,LEN(D3)-FIND("-",D3))),LEN(RIGHT(D3,LEN(D3)-FIND("-",D3)))-1)))/0.0254

Please can you assist me.

Thanks

I need to convert Meters to Feet and Inch measurments. I need it in
fractional format I.e. 1/4, 1/2, 3/8, 5/16, 8/32.
Ex. 1 Meter
= 3 1/2 Feet

Convert feet and inches to decimal feet.

--------------------------------------------------------------------------------

In column A1, I use for example: 6-11 (Text) and want to covert to decimal feet in column B1 (6.9166666666667).
Have been working on this for a week! With no luck.
6-11 is easy to type in a field and represents 6'-11"
Thanks

Hi,

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

I've just recieved a spreadsheet of x and y coordinated in easting and northing in cm. To be able to use this data I need to be able to convert this to Longitude and Latitude in degrees. I've looked at the excel functions but havn't been able to find anything that looks as if it will help is anyone able to come up with a macro solution?

I need help to convert Decimal to Fraction
I use this code

	VB:
	
 
    Dim 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 Function 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
It comes out like 89/8, but i want something like 11 1/8

Can please anyone help me to solve this???

Thank you!!

Hi team. I'm sure that this must have been covered before but I'm stuck.

We keep students grades as A-, B+ etc and convert these to a numerical value at the end of
each course. I have this part of my spreadsheet working and end up with a total figure (out of
100) for each student. So far so good.

Now I'm trying to take that score and convert it back into a final grade. Each grade relates to
a range of scores, so 90+ = A+ and so forth. I'm not far from getting it sorted but Excel keeps
rejecting my formula and I'm still a luddite with these things. Here's my formula.

=IF(S41>89,"A+",IF(S41>84,"A",IF(S41>79,"A-",IF(S41>74,"B+",IF(S41>69,"B",IF(S41>64,"B-",IF(S41>59,"C+",IF(S41>54,"C",IF(S41>49,"C-",IF(S41>39,"D",IF(S41>0,"E"))))))))))))

Have I got too many closed brackets on the end, or am I trying to process too many functions
within the one formula? I'm quite new to the darker parts of Excel so be gentle please!