Formula to fill a cell

N

Nikki

What is the new formula in Office 2003 to fill a cell with
a symbol. I used to use /- which was from lotus. That
will not work now and the repeat function will only give
you the option on a specific number.
 
B

Bernie Deitrick

Nikki,

Use

=REPT("-",1000)

and put a space in the cell to the right, which will truncate the long line
of -s at the end of the cell with the formula.

HTH,
Bernie
MS Excel MVP
 
R

RagDyeR

<Format> <Cells> <Alignment> tab,

And expand the "Horizontal" box and click on "Fill", then <OK>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


What is the new formula in Office 2003 to fill a cell with
a symbol. I used to use /- which was from lotus. That
will not work now and the repeat function will only give
you the option on a specific number.
 
D

Don Guillett

Here's something else that you may like
try putting - in the cell to get-------------
try putting space - in the cell to get - - - - - -
 
Top