LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
sjl sjl is offline
external usenet poster
 
Posts: 8
Default convert to feet and inches

if i have a value such as 1.9878 and want to show it to the nearest feet and
inches how would i do it?


 
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
How to convert 120608 in Excel into 12 Feet 6 inches 8 sixteenths Trussman Excel Worksheet Functions 12 September 27th 06 07:33 PM
Convert feet/inches to decimal dingy101 Excel Worksheet Functions 16 February 21st 06 10:18 PM
How do I convert Meters to Feet and Inches? Dave S Excel Worksheet Functions 7 December 16th 05 11:33 AM
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 10:42 AM.

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

About Us

"It's about Microsoft Excel"