| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cell
how do I format a cell to show feet and inches
as in 21'-10" or 12" in Excell 2003 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format cell
If you enter 5' 03" as 503 then
format the cell as CUSTOM ##0' \- 00\" to see 5.03 as 5' - 03" If you can live with a helper column then if your values are in A1 in feet.inches form then enter this in B1 =INT(A1)&"' - "&ROUND((A1-INT(A1))*100,0)&"""" "cruser" wrote: how do I format a cell to show feet and inches as in 21'-10" or 12" in Excell 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| Excel Auto-Format cell to email format | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Linear Mode
