software

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

A custom format like:

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

--

Dave Peterson

Thank you for the information. It works fine. I didn't realise you could edit
the custom samples.
--
Mikequot;Mikequot; wrote:

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

I'm not sure you can edit the built-in custom formats--but you can surely use
them as a basis for your own custom format (kind of a semantic thing, though).

Mike wrote:
gt;
gt; Thank you for the information. It works fine. I didn't realise you could edit
gt; the custom samples.
gt; --
gt; Mike
gt;
gt; quot;Mikequot; wrote:
gt;
gt; gt; I have one column which is formatted to show inches and fractions of an inch.
gt; gt; 1/16, 1/8, 3/16, 1/4 and so on up to 15/16. It works perfectly except that I
gt; gt; want it to show a leading zero when the fraction is smaller than one inch. eg
gt; gt; 0 15/16, not 15/16. Is there any way to format the cell to do that?.
gt; gt; --
gt; gt; Mike

--

Dave Peterson