View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
dhstein dhstein is offline
external usenet poster
 
Posts: 266
Default Filling a cell with "-"

Thanks to all for the responses.

David


"Dave Peterson" wrote:

Type
-
Into a cell.
You'll have to either preformat the cell as text or start with a leading
apostrophe:
'-

Then Format|cells|Alignment tab|Horizontal Text Alignment|choose Fill
(xl2003 menus)



dhstein wrote:

I want a cell to contain all "-" (hyphens) no matter how wide the column is.
So if I make it wider or narrower, there will be a line of hyphens. Thanks
for any help on this.


--

Dave Peterson