Want decimal number to convert to inch fraction like 1/8, 1/4, 3/16, 7/8.....
Want decimal number to convert to inch fraction like 1/8, 1/4, 3/16, 7/8.....
yes this method does yeild fractions however they are not necessarily fraction found on a tape measure. 3/5 s ?? What is 3/5 s of an inch??? D 1/8, a
1.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. Cheers in advance Dee
2.Foot and inches with fractions to inches and decimal points
Morning, We have a program that exports a table to excel. 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
3.How do I convert decimal inches to fractions in excel
Have reports from Cad/Cam "CadCode" with mesurements in decimal inches. would like to convert to fractions ( 1/2",1/4",3/32" ect..) Have formula for 1 cell at a time but whole row ( or whole document) would be quicker
4.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. Thank you for your help.
5.convert decimal to inch & fraction
CAN YOU FORMAT A CELL TO CONVERT DECIMALS TO INCH & FRACTION OF INCH?
6. Feet, inch, fraction to Decimal conversion
7. how to convert feet-inches-fractions to feet (or inches) in Excel
Users browsing this forum: No registered users and 65 guest