Im trying to convert this Plate 1/2"x2'-6 9/16" in excel to look like this 1/2"x30 9/16". is there a way to strip the word "plate" off and convert the 2'-6 9/16" to 30 9/16" im new to excel any help would be great...

- Convert feet and inches to deimal feet.
- Convert feet and inches to decimal feet
- Convert feet and inches to meters
- Convert feet and inches to inches
- Convert feet and inches to metres
- Convert "yes" and "no" to "1" and "0", respectively
- Convert Whole Number Inches to Format "xxFT xxIN"
- How do I convert decimal to feet and inches
- Convert fractions to decimals and decimal to fraction
- Fraction in 16ths format reduced to LCD:converting it into inches
- Convert Feet & Inches to Metres
- Function to convert feet and inchs into decimal equivalents
- Multiply cell with foot and inch
- Change feet and inches to decimal inches
- Help: Converting Pluses and Times to Sum and Product Functions ???
- Multiply cell with foot and inch
- Converting hours and minutes to minutes
- VBA converts dates and numbers to US formats. Can I prevent this?
- Need to convert hours and minutes to hours and tenths.
- Convert Feet and Inches into Barrels
- Convert minutes and seconds to seconds
- Convert hours and minutes to minutes
- Hours and minutes to decimal
- Formatting cells for feet and inches

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

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

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

=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

Tried : =(1*(LEFT(A1,FIND("-",A1)-1)*12+MID(A1,FIND("-",A1)+1,2)))+IF(LEN(A1)=LEN(SUBSTITUTE(A1,"1/2",""))

and nothing happened?

like then to do analysis using SPSS. Thank you.

I've been working on a project for work for the last couple weeks and this forum has proven to be invaluable when it comes to working through issues. I couldn't find this one through searching, so alas i will post.

One element of this project is converting a length from textbox "txtLength." I have this box setup so it can be only whole numbers, no fractions/decimals/letters/etc. However, i need to manipulate this number and change it's length so i can later print the length to a Bill of Materials. It's not practical to print this length as inches, because the length could be as high as 360 inches.

Here's where i'm at, i'm having a difficult time wrapping my head around the correct way to approach this.

VB:Any direction you could provide would be a big help!LengthConverter() Dim sLength As String 'This is the final format of "XXFT XXIN" Dim iLength As Integer 'This is the original format of "XXIN" iLength = txtLength.Value End SubIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Thanks,

Nate

Edit: Working through this a little more and it should be something like this, i just don't know the correct functions in excel:

VB:Am i getting closer?Public Sub LengthConverter() Dim iLengthFT As Integer Dim iLengthIN As Integer Dim sLength As String sLengthFT = (iLength/12) With a method To drop the remaining decimal To the Next calculation of: sLengthIN = (Remainder(iLength/12))*12 'Round this up to whole number Then would need a method To concatenate the "FT" And "IN" units To the End of the integers. End SubIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

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

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?

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'd like to find a way of converting feet and inches (expressed as, for example = 12'4") to metres (m). I won't be using any imperial fractions.

I've had a play with the convert funtion which manages to do one or the other (eg feet to metres, inches to metres) but not both together. Of course I'm sure it does but my excel knowledge is woeful. Any help would be greatly appreciated.

able to do calculations on which I think I can only do by converting them

into their decimal equivalents.

Does anyone know a function or some other way to convert these?

format such as 4'33". Then how do I multiply 2 cell

together to produce square foot. Example A1=4'33" and

B1=3'33" which is equal 14.42 Sq.Ft.

Thanks.

Before (2"-4 1/2") after (28.5)

I would like to us a formula or number type to convert.

properly in the Excel environment. Lotus apparently treats text in cells as 0

or 1 values so that when they are added or multiplied (with operands) it has

no net effect on the value that results. Excel returns an error message when

using operands to sum/multiply values with text. I did discover that Excel

does what I need it to do when using the =SUM() and =Product() functions. I

updated all the formulas by hand in one sheet and then found that there are

69 more sheets and the formulas are irregular.

Does anyone have any idea how to write a VBA macro that will parse the

spreadsheet and convert all the formulas to use SUM and/or PRODUCT instead of

" + " and " * "?

Example

Convert: " =ROUND ( (+CO34 +DA34 -AA33) * DD34,0) "

To: " =ROUND (PRODUCT (SUM (CO34,DA34,-AA33) ,DD34) ,0) "

or

To: " =ROUND (PRODUCT (SUM (CO34) + SUM (CO34) - SUM (AA33) ,1) * PRODUCT

(DD34,1) ,0) "

Both methods seem to give me the same result. The second way is easier for me

to approach, but I haven't been able to nail it down.

Thank you!

format such as 4'33". Then how do I multiply 2 cell

together to produce square foot. Example A1=4'33" and

B1=3'33" which is equal 14.42 Sq.Ft.

Thanks.

I have an Excel sheet in with 2 columns: Column A holds a date in the European format "dd/mm/yyyy" and column B holds a number in the European format "#.###.##0,00".

This data is used to complete a listbox in a userform so the user can choose with which date and number to continue some calculations.

Now, when completing the as follows, the values are casted to strings with the wrong value:

Code:

UCList.AddItem UCList.List(UCList.ListCount - 1, 0) = MyCell.Value UCList.List(UCList.ListCount - 1, 1) = MyCell.Offset(0, 1).ValueIf I check in the "Wachtes" window, mycell.value = 65,864356134631 (sixty five and then some decimals) and mycell.offset(0,1).value = 03/02/2008 (February 3rd). After assigning the values to the list, these value become 65864356134631 and "02/03/2008". If I later on call this date form the UCList, the date becomes the 2nd of March and the number a huge number (=+/- 6*10^14 ).

The problem probably is most likely caused by the cast to string when completing the list and the cast to double or date when reading the list values.

Is there a way I can tell VBA that I live in Europe and that we use a different date system? Just like you can set it in Excel in Tools>Options>Internation>Number Handling?

I can solve this by using

Code:

UCList.AddItem UCList.List(UCList.ListCount - 1, 1) = format(MyCell.Value,""#,###,##0.00") UCList.List(UCList.ListCount - 1, 1) = format(MyCell.Offset(0, 1).Value,"dd/mm/yyyy")but this is just one of those patches which does not really solve the root problem.

In addition, this continuously switching from US to European date and number format, makes my code quite confusing.

Any help on this will be highly appreciated.

by adding the hours and multiplying the minutes by 1.666667. example 8 hours

and 30 minutes - =8+.30*1.666667 - results in 8.50. I have to manually

enter this for all hours and minute I want to convert to hours and tenths. I

am looking for a formula that can be entered in a cell that will

automatically convert the hours and minutes computed in the previous cell to

hours and tenths.

I need to convert hours and minutes 1:45 (One Hour and 45 Minutes) into total

minutes... Any ideas

minutes... Any ideas

Currently I have 37:30 (thirty seven hours: 30 minutes) but in order to multiply it i need it to be 37.5 hours.

Any help would greatly be apprciated...

thanks so much

sklnxbones

For example, if I type 6.738 in a cell, I want it to display 6'-8 7/8".

I know how to use the lentext() and feet() modules, but they are not cell formats.

Any ideas?