700
Chapter 25 Advanced Worksheet Formatting
Table 25.3 Custom Text Format Codes
Code What It Does How You Use It
* Repeat characters to Enter an asterisk followed by the character you want
fill cell to column to repeat. Use *- in the third position of a custom
width format to replace zero values with a line of hyphens,
for example.
_ (underscore Add a space the width Enter an underscore followed by the character whose
character) of a specified width you want to use. Several built-in formats use
_))
character with positive number formats, for example, to make
sure they line up properly with negative numbers that
use parentheses.
\ Display the character ...