Then I guess I am not following what you want or need. What are you
physically going to type into the cell you asked to be able to format? Where
does the A, B, C, D you asked about come from? You are going to have to give
us a little more detail about your layout, what is typed where, what you
want to look like what where, etc.

Rick


"Rick" wrote in message
...
The number part as well as the alpha part can be anynumber and any alpha.
It
is a trace code for medical billing, but the format will always be the
same.

"Rick Rothstein (MVP - VB)" wrote:

Is the "number" part always going to be 07-108029827? In other words,
what
do you want to TYPE into the cell and what do you want appear? If the
number
part is not the same all the time, where is it coming from?

Rick

"Rick" wrote in message
...
Is there anyone out there that can tell me how to create a format that
does
this:
07-108029827-A it's the A that needs to be a substitue alpa
character,
because the A may have to be a B, or C, or D.

Thanks