LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
JB
 
Posts: n/a
Default How do I set a cell format for Feet and Inches? i.e. 3'-10 1/2"

How do I set a format in cells to display feet and inches as follows?

3'-10 1/2"

or

3-10 1/2
 
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
concatenating from a different cell within the same row method373 Excel Discussion (Misc queries) 6 February 16th 06 10:24 PM
Cell format inch marcia Setting up and Configuration of Excel 1 November 7th 05 04:25 PM
Special format for feet - inches in a cell Bothell John Excel Discussion (Misc queries) 1 September 8th 05 12:28 AM
How can I show Feet and inches in a Excel cell? Magama13 Excel Discussion (Misc queries) 1 January 28th 05 03:27 PM
How can I format a cell to accept feet and inches and add them Jack Excel Worksheet Functions 4 November 4th 04 12:30 AM


All times are GMT +1. The time now is 05:27 PM.

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"