Hi Josh,

The custom format: -------@-------- should do what you are after if the
number lines before and after is fixed.

If you want the enire string to be a fixed length something like REPT("-",(10-
(LEN(B1))))&B1&REPT("-",(10-(LEN(B1)))) where 10 is the fixed with should do

HTH

Simon

================================================== ======================

Josh O. wrote:
I know its possible to have a symbol/text repeat before or after text in a
field.
Using, for example, *- custom number format.

Is it possible to have a repeating character before and after text?
Centered between the leading and trailing characters.
Example:
|----- Text -----|

Thanks for any help.

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200801/1