EXCEL
Custom Formats
If
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.

Click
on the links below to see how to create custom formats for various types of
data:
Months,
Days and Years
Hours, Minutes and Seconds
Numbers
Colour
Currency Symbols
Percentage
Scientific Notation
Adding Characters
Text Section
Adding Space
Repeating Characters
You
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.
webmaster@allaboutoffice.co.uk |