Filling a cell with "-"
 

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.

Filling a cell with "-"
 

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

Filling a cell with "-"
 

=REPT("-",100)

"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.

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