I have a custom list for items I've sold, traded or given away, and therefor don't want to have a collection number associated with them.

I set the options for no collection numbers then added a bunch of items, and then somehow they all had the value "69" for collection number.

How can I blank these collection numbers out all at one go?

I've got over a thousand titles with this problem, so it would really be tedious to do one at a time, and I can't figure out how to do this just using the "reassign collection number" button.

Right now the only way I know how to do it is to set "allow collection numbers" for the custom list and then edit each profile one at a time.