S
Stinky Pete
Hi everyone,
I'm new to programming in Excel, so please be patient ;-)
I'm using an Excel 2000 (corporate policy) worksheet into which our
plant operators currently manually enter a unique batch number in the
text format of aaa-bbb. In reality, if you break the number down,
it's (alpha numeric)(alpha numeric)(numeric)-(numeric)(numeric)
(numeric) and for example it could be 9a5-123 or adr-456 etc.
Anyway, I wish to remove the possibility of the operators not
including the hyphen which could spell havoc when the product ends up
in customer land as it MUST be completely traceable.
So, any suggestions on how to allow the operators enter a text sting
as aaabbb and then get excel to format the text as aaa-bbb ??? I've
had a look at the group and nothing quite seems to fit. Thanx to the
group though, I did found some cool code that helps change any text to
uppercase.
Stinky Pete ;-)
I'm new to programming in Excel, so please be patient ;-)
I'm using an Excel 2000 (corporate policy) worksheet into which our
plant operators currently manually enter a unique batch number in the
text format of aaa-bbb. In reality, if you break the number down,
it's (alpha numeric)(alpha numeric)(numeric)-(numeric)(numeric)
(numeric) and for example it could be 9a5-123 or adr-456 etc.
Anyway, I wish to remove the possibility of the operators not
including the hyphen which could spell havoc when the product ends up
in customer land as it MUST be completely traceable.
So, any suggestions on how to allow the operators enter a text sting
as aaabbb and then get excel to format the text as aaa-bbb ??? I've
had a look at the group and nothing quite seems to fit. Thanx to the
group though, I did found some cool code that helps change any text to
uppercase.
Stinky Pete ;-)