Formula to fill a cell

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

 

[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

 

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

 

[Don Guillett]

try selecting the cell and then using
Format>Cells>Alignment>Horizontal>Fill

 

[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 - - - - - -

 

[Nikki]

Thanks that worked great!

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

--
Don Guillett
SalesAid Software
(e-mail address removed)



.

 

[Don Guillett]

glad to help