Enforcing a Cell format

[dok112]

Hey everyone, I need some help. I have tried everything I can think of to enforce this, but I keep running into errors.

Any values in column B or C I need to have a specific format "### - ########## - ######## - ##/##/####"

I thought about just using a concatenate formula, but it was causing too much excess work. My employee's are aware they are to enter it in this format, but in case they enter it incorrectly, I want the cell to update to the correct format.

EX.

TEL - TRV303902 - I322390I - 04/21/2006
ABC - TRV000000 - INV33029I - 04/21/2006

The variables can change in each field. The first set will always be 2-3 letters depending on the initials of the person making the entry. the next 2 sets can range anywhere from 5-9 alphanumeric characters, and the last set will always be a date. And I need it to be hyphenated like above as well.

Any help will be greatly appreciated!! Thanks y'all!

[Tom Ogilvy]

Your entering text and you can't format text.

You might want to explore the Change Event
http://www.cpearson.com/excel/events.htm
if your are not familiar with events.

--
Regards,
Tom Ogilvy

"dok112" <[email protected]> wrote in
message news:[email protected]...
>
> Hey everyone, I need some help. I have tried everything I can think of
> to enforce this, but I keep running into errors.
>
> Any values in column B or C I need to have a specific format "### -
> ########## - ######## - ##/##/####"
>
> I thought about just using a concatenate formula, but it was causing
> too much excess work. My employee's are aware they are to enter it in
> this format, but in case they enter it incorrectly, I want the cell to
> update to the correct format.
>
> EX.
>
> TEL - TRV303902 - I322390I - 04/21/2006
> ABC - TRV000000 - INV33029I - 04/21/2006
>
> The variables can change in each field. The first set will always be
> 2-3 letters depending on the initials of the person making the entry.
> the next 2 sets can range anywhere from 5-9 alphanumeric characters,
> and the last set will always be a date. And I need it to be hyphenated
> like above as well.
>
> Any help will be greatly appreciated!! Thanks y'all!
>
>
> --
> dok112
> ------------------------------------------------------------------------
> dok112's Profile:
http://www.excelforum.com/member.php...o&userid=10581
> View this thread: http://www.excelforum.com/showthread...hreadid=544913
>