| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
format number in feet and inches
Id there a way to format a number to feet and inches, i.e 6.25 to display as
6' 3"?? |
|
#2
|
|||
|
|||
|
Try:
=INT(A1)&"'-"&ROUND(MOD(A1,1)*12,0)&"""" HTH Jason Atlanta, GA -----Original Message----- Id there a way to format a number to feet and inches, i.e 6.25 to display as 6' 3"?? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate formulas with feet & inches | Excel Worksheet Functions | |||
| How can I show Feet and inches in a Excel cell? | Excel Discussion (Misc queries) | |||
| Converting inches to feet & inches. | Excel Worksheet Functions | |||
| format numbers into feet / inches | Excel Worksheet Functions | |||
| How can I format a cell to accept feet and inches and add them | Excel Worksheet Functions | |||
Linear Mode
