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?

## Related Results

### Converting pixels to inches

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.

### Convert decimal to inch & fraction

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

### Change default measurements from cm to inches

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.

### Convert mm to inches

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

### Convert mm to inch

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?

```

```

### Convert decimal to inch & fraction

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

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

### Converting from feet, inches and fractions to inches and decimal p

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.

Dee

### Feet, inches and fractions to inches and dec.....reposting for Pet

Hey Pete_uk,
No idea why it's not coming up.

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

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.
> >
> >
> > Dee
>
>
>

### Convert fractions to decimals and decimal to fraction

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?

### Convert Decimals To Feet & Inches

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

### Formula for converting decimal to inch & fraction

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

### How do I convert decimal to feet and inches

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.

### Formula for converting decimal to inch & fraction

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

### Convert decimals to feet / inches in excel

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

### Convert feet and inches to decimal feet

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

### Fraction in 16ths format reduced to LCD:converting it into inches

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.

### Convert feet and inches to meters

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

Thanks

### How do I convert Meters to Feet and Inches?

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

### Convert mm to fractional inches

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

### Easting and northing in cm to longitude and latitude

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?

### Convert Decimal to Fraction

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!