Repeat characters to cell width

[David]

Greetings and TIA for your time,
I vaguely remember with Lotus 123 that it was possible to repeat characters
to the cell width without specfying the cell width. For example, if I
remember right, "/-" would produce 1 cell width of hyphens: -----------------
Is there an equivalent for Excel?
--
David

[Niek Otten]

Hi David,

* will cause the following character to fill the width.

Use it in Format>Cells>Number>Custom

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"David" <David@discussions.microsoft.com> wrote in message
news:B0B0335D-E844-4AA3-B4C3-1B115DAC8CCE@microsoft.com...
> Greetings and TIA for your time,
> I vaguely remember with Lotus 123 that it was possible to repeat
> characters
> to the cell width without specfying the cell width. For example, if I
> remember right, "/-" would produce 1 cell width of
> hyphens: -----------------
> Is there an equivalent for Excel?
> --
> David

[Dave Peterson]

Format|cells|alignment tab
Horizontal dropdown: Choose Fill.



David wrote:
>
> Greetings and TIA for your time,
> I vaguely remember with Lotus 123 that it was possible to repeat characters
> to the cell width without specfying the cell width. For example, if I
> remember right, "/-" would produce 1 cell width of hyphens: -----------------
> Is there an equivalent for Excel?
> --
> David

--

Dave Peterson