View Single Post
  #2   Report Post  
Old March 6th 04, 02:40 PM posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27,285
Default 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