I am familiar with the format you referenced. And thanks for the formula, I
would had thought of trying it that way (although I would have to rethink how
the user enters data in the field in order to use it this way...hummm. Have
to think on it a bit).
Unfortunately, the cell(s) are not a fixed width. That kindof throws a
monkey wrench into it.
"smw226 via OfficeKB.com" wrote:
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