• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Repeating Characters

You can fill cells with remaining characters or repeating characters. No matter what the column width, the repeating characters will always fill up the remaining space in a cell. If you have dollar values similar to how dollar values are filled out in checks and repeating characters take up the remaining space, this is a good way to establish the repeating characters. To create repeating characters, type the following into the Type formula bar:The Type format bar is in the format cells dialog box under the Category Custom.

001 0*~
002 


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint