hi there,

I?ve got a list of equipments that are tagged with the company?
inventory number. Each item has its own tag which?s composed by eigh
characters and the first is separated by an "-" , like this example
*1-0012345*.

Unfortunately the list is generated by an old system that can hold onl
12 character tags and doesn?t support any other symbols.
Therefore, it puts a couple of ZEROS to replace the " - " symbol, an
another couple of ZEROS at the end to sum up 12 characters.
In the end the tags look like: *100001234500*.

How can I format the tag column to display the odd 12 characters in th
8 number fashion?
I guess it?s like saying to excel to replace the 2nd and 3rd number
with an " - ", and forget about the last two ZEROS.

Is that possible ?

TI