Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 96
Default How do I convert decimal to feet and inches

I've seen the other posts but they deal with smaller numbers or different
formats. I need to convert 188.76 inches to feet and inches.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,339
Default How do I convert decimal to feet and inches

=INT(A1/12)&" ft "&TEXT(MOD(A1,12),"#.00")&" ins"

"Erik" wrote:

I've seen the other posts but they deal with smaller numbers or different
formats. I need to convert 188.76 inches to feet and inches.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,339
Default How do I convert decimal to feet and inches

or ...

=INT(A1/12)&" ft "&ROUND(MOD(A1,12),2) &" ins"

"Erik" wrote:

I've seen the other posts but they deal with smaller numbers or different
formats. I need to convert 188.76 inches to feet and inches.

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 96
Default How do I convert decimal to feet and inches

Genius! Thank you this worked great.

"Toppers" wrote:

or ...

=INT(A1/12)&" ft "&ROUND(MOD(A1,12),2) &" ins"

"Erik" wrote:

I've seen the other posts but they deal with smaller numbers or different
formats. I need to convert 188.76 inches to feet and inches.

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 96
Default How do I convert decimal to feet and inches

I need to know if you can add the fractions in 16ths?

"Toppers" wrote:

or ...

=INT(A1/12)&" ft "&ROUND(MOD(A1,12),2) &" ins"

"Erik" wrote:

I've seen the other posts but they deal with smaller numbers or different
formats. I need to convert 188.76 inches to feet and inches.



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default How do I convert decimal to feet and inches

Yes.

If you want the input in 16ths, just use something like 188 13/16.
If you want the output in 16ths, change the formula from
=INT(A1/12)&" ft "&TEXT(MOD(A1,12),"#.00")&" in" to
=INT(A1/12)&" ft "&TEXT(MOD(A1,12),"# ??/16")&" in"
--
David Biddulph

"Erik" wrote in message
...
I need to know if you can add the fractions in 16ths?

"Toppers" wrote:

or ...

=INT(A1/12)&" ft "&ROUND(MOD(A1,12),2) &" ins"


"Erik" wrote:

I've seen the other posts but they deal with smaller numbers or
different
formats. I need to convert 188.76 inches to feet and inches.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula to convert decimal feet to feet inch sixteenths tv Excel Discussion (Misc queries) 24 May 3rd 23 11:41 AM
How can i see on excel feet and inches from decimal system? Sharky Excel Worksheet Functions 4 February 27th 06 08:44 PM
Convert feet/inches to decimal dingy101 Excel Worksheet Functions 16 February 21st 06 11:18 PM
is there a macro that will convert from inches to feet and inches cable guy Excel Discussion (Misc queries) 1 June 20th 05 07:29 PM
How do i convert feet and inches to a decimal value? go_chrisg Excel Worksheet Functions 4 May 22nd 05 04:33 PM


All times are GMT +1. The time now is 02:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"