EXCELAdding Space using Excel Custom FormatsTo 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. |
