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?

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 pixels to inches
- Convert decimal to inch & fraction
- Change default measurements from cm to inches
- Convert mm to inches
- Convert mm to inch
- Convert decimal to inch & fraction
- Convert cm to inches
- Converting from feet, inches and fractions to inches and decimal p
- Feet, inches and fractions to inches and dec.....reposting for Pet
- Convert fractions to decimals and decimal to fraction
- Convert Decimals To Feet & Inches
- Formula for converting decimal to inch & fraction
- How do I convert decimal to feet and inches
- Formula for converting decimal to inch & fraction
- Convert decimals to feet / inches in excel
- Convert feet and inches to decimal feet
- Fraction in 16ths format reduced to LCD:converting it into inches
- Convert feet and inches to meters
- How do I convert Meters to Feet and Inches?
- Convert feet and inches to deimal feet.
- Convert mm to fractional inches
- Easting and northing in cm to longitude and latitude
- Convert Decimal to Fraction
- Converting scores to grades

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.

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.

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

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?

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?

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

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

>

>

>

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?

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

I am using Excel 2000.

Thank you for your help.

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

I am using Excel 2000.

Thank you for your help.

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 format. How do I reduce resulting fractions to lowest term - I don't

want to see 8/16 but do want 1/2.

=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

fractional format I.e. 1/4, 1/2, 3/8, 5/16, 8/32.

Ex. 1 Meter

= 3 1/2 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

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

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!