| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display number as feet and inch in single cell
How can I display a number as feet and inch in single cell, ie. 8.5 to
display 8'-6" |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display number as feet and inch in single cell
You could do it with a user defined function e.g.
Function d_to_fi(numberarg As Double) feet = Int(numberarg) inches = Format((numberarg - Int(numberarg)) * 12, "#0") d_to_fi = feet & " ' - " & inches & """" End Function "covdbrdg" wrote: How can I display a number as feet and inch in single cell, ie. 8.5 to display 8'-6" |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display number as feet and inch in single cell
It can be done with a formula:
=INT(A1)&CHAR(39)&"-"&MOD(A1,INT(A1))*12&CHAR(34) ....but I don't know if there is a way to create a custom format to do it. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display number as feet and inch in single cell
Or you could use a formula:-
=(TEXT(INT(A1),"0")&"' "&TEXT((A1-INT(A1))*12,"0")&"""") "covdbrdg" wrote: How can I display a number as feet and inch in single cell, ie. 8.5 to display 8'-6" |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display number as feet and inch in single cell
Thanks, but, How do I create a user defined function?
"bigwheel" wrote: You could do it with a user defined function e.g. Function d_to_fi(numberarg As Double) feet = Int(numberarg) inches = Format((numberarg - Int(numberarg)) * 12, "#0") d_to_fi = feet & " ' - " & inches & """" End Function "covdbrdg" wrote: How can I display a number as feet and inch in single cell, ie. 8.5 to display 8'-6" |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display number as feet and inch in single cell
I GOT IT FROM ANOTHER POST... I need to be able to do this in a singlt cell,
like formatting. "covdbrdg" wrote: Thanks, but, How do I create a user defined function? "bigwheel" wrote: You could do it with a user defined function e.g. Function d_to_fi(numberarg As Double) feet = Int(numberarg) inches = Format((numberarg - Int(numberarg)) * 12, "#0") d_to_fi = feet & " ' - " & inches & """" End Function "covdbrdg" wrote: How can I display a number as feet and inch in single cell, ie. 8.5 to display 8'-6" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to convert decimal feet to feet inch sixteenths | Excel Discussion (Misc queries) | |||
| Suggestion for new cell formats for Feet and Inch | Excel Discussion (Misc queries) | |||
| display feet and inches | Excel Discussion (Misc queries) | |||
| Format numberformat Single | Excel Worksheet Functions | |||
| HOW CAN I SHOW OUTPUT IN FEET INCH FORMAT | New Users to Excel | |||
Linear Mode
