Hi David,

* will cause the following character to fill the width.

Use it in FormatCellsNumberCustom

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"David" wrote in message
...
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