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.