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 |
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 |
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 . |
All times are GMT +1. The time now is 12:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com