Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
person's height format
Is there a way to format a cell so you only have to type
the numbers for a person's height as in 5 8, and the ' " will automatically fill in? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
person's height format
Once you put the space in, the entry becomes text and cell formatting
doesn't work well with text. You could enter 58 (5' 8") or 610 (6' 10") using this custom cell format: [<100]#' #'';#' ##\" or to treat 5 as 5' [<10]#';[<100]#' #'';#' ##\" -- Regards, Tom Ogilvy "Logan" wrote in message ... Is there a way to format a cell so you only have to type the numbers for a person's height as in 5 8, and the ' " will automatically fill in? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
person's height format
That works for me.
Thanks Tom -----Original Message----- Once you put the space in, the entry becomes text and cell formatting doesn't work well with text. You could enter 58 (5' 8") or 610 (6' 10") using this custom cell format: [<100]#' #'';#' ##\" or to treat 5 as 5' [<10]#';[<100]#' #'';#' ##\" -- Regards, Tom Ogilvy "Logan" wrote in message ... Is there a way to format a cell so you only have to type the numbers for a person's height as in 5 8, and the ' " will automatically fill in? Thanks . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row height will not auto format | Excel Worksheet Functions | |||
How do I specify row height, number format upon startup of Excel? | Excel Discussion (Misc queries) | |||
How do I format excel if cell value is = to 0 then row height = 0 | Excel Discussion (Misc queries) | |||
Excel 2003 row height format | Excel Discussion (Misc queries) | |||
How do you enter person's height in cell? | Excel Worksheet Functions |