Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading zero with fractions
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading zero with fractions
A custom format like:
0 ??/?? 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading zero with fractions
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: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove leading space | Excel Worksheet Functions | |||
Spliting a number with leading zeros | Excel Discussion (Misc queries) | |||
Concatenation with leading zeros | Excel Worksheet Functions | |||
fractions turn into dates when pasting in excel 2003 | Excel Discussion (Misc queries) | |||
Leading zeros | Excel Discussion (Misc queries) |