Click here for great value web hosting.

ALL ABOUT OFFICE

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT




Search for
 

help


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