Click here for great value web hosting.

ALL ABOUT OFFICE

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT




Search for
 

help


EXCEL

Adding Space using Excel Custom Formats

To create a space the width of a character in a number format, include an underscore (_) followed by the character. For example, when you follow an underscore with a closing parenthesis _), positive numbers line up correctly with negative numbers that are enclosed in parentheses.  An example of this is shown in the custom format below, notice how the numbers in the column line up correctly despite the fact that some contain brackets.

Click here to return to the Excel index.

webmaster@allaboutoffice.co.uk