View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default 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