the predefined formats do not meet your requirements you can try to create your
own custom format to apply to the cells. This
is done by entering a special code representing the layout of the text and
numbers in the Type box that appears when you select Custom from
the Number section of the Format Cells window.
on the links below to see how to create custom formats for various types of
Days and Years
Hours, Minutes and Seconds
may need to combine information from several of the above sections to create the
format you need.
Click here to
return to the Excel index.