I have an object X which has Standard Name field as autonumber. There are about 10000 records in tht object. Upon checking found out that out of 10000, only 600 records are in autonumber, rest all are in aribitary text. Not sure how it happened. Now need to fix it.
I want to fix it like the oldest record should start from A-00000 and the sequence will go on and the last record should end with A-10000.
How to achieve this.