View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike
 
Posts: n/a
Default Leading zero with fractions

Thank you for the information. It works fine. I didn't realise you could edit
the custom samples.
--
Mike


"Mike" wrote:

I have one column which is formatted to show inches and fractions of an inch.
1/16, 1/8, 3/16, 1/4 and so on up to 15/16. It works perfectly except that I
want it to show a leading zero when the fraction is smaller than one inch. eg
0 15/16, not 15/16. Is there any way to format the cell to do that?.
--
Mike