Indexing Ideas Needed - Parts I.D. Order in Libraries : Ex.) Parts R1 thru R10, R2...

GOAL:

To resolve the subject line issue that is intensive and eliminates the following workaround.

WORKAROUND

A sequential number in a separate index number is formatted as a "Number". Many times I must export the library and add the number in MS Excel and paste these back into the library's index number column.

IDEAS ON RESOLUTION

Your thoughts on how to properly index the part I.D.s without a separate index number column are welcome including:

• Alternative formatting to apply to the alphanumeric Part I.D. description in the Part I.D. column to promote correct indexing
• Any programmed solutions

Best regards,

Clint Hill