Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Feet, inches and fractions to inches and dec.....reposting for Pet
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 |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Feet, inches and fractions to inches and dec.....reposting for Pet
Hi Dee,
I was eventually able to see your posting and adjusted the formula to suit - I've replied to your original thread. Note that the line breaks occur wherever there is a space between double-quotes, i.e. at " " in the formula. Hope this helps. Pete On Sep 18, 3:34 pm, Dee wrote: 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- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting from feet, inches and fractions to inches and decimal p | Setting up and Configuration of Excel | |||
Fractions, Feet, Inches, & macros | Excel Discussion (Misc queries) | |||
Is there a formula for inches to feet and inches? | Excel Worksheet Functions | |||
is there a macro that will convert from inches to feet and inches | Excel Discussion (Misc queries) | |||
Converting inches to feet & inches. | Excel Worksheet Functions |