ExcelBanter - eXCEL ENGINEERING TO ARCHITECTURAL MEASUREMENTS

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - eXCEL ENGINEERING TO ARCHITECTURAL MEASUREMENTS (https://www.excelbanter.com/excel-worksheet-functions/88428-excel-engineering-architectural-measurements.html)

EDPISTOL

eXCEL ENGINEERING TO ARCHITECTURAL MEASUREMENTS

LOOKING FOR CONVERTER FOR EXCELL TO CONVERT DECIM TO FEET AND INCHES

Ron Coderre

eXCEL ENGINEERING TO ARCHITECTURAL MEASUREMENTS

Try something like this:

For a decimal value in A1

B1: =INT(A1/12)&"' "&MOD(A1,1)*12&""""

If A1: 15.257
B1 returns 1' 3.084"

Is that something you can work with? Or are you looking for something else?

***********
Regards,
Ron

XL2002, WinXP

"EDPISTOL" wrote:

LOOKING FOR CONVERTER FOR EXCELL TO CONVERT DECIM TO FEET AND INCHES

All times are GMT +1. The time now is 04:06 PM.