This question already has an answer here:

I have a standard field that I have assigned the following Display format "A-{0000}". What happens when it reaches A-9999? I'm not able to find the answer online and I want to make sure it does not restart. I need this to be a unique field.

marked as duplicate by gNerb, battery.cord, Vijay Ganji, dphil, Pranay Jaiswal Jun 21 at 9:16

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • The "possible duplicate" says "I don't know what happens when it hits 11 digits" so does not answer this question. – Keith C Jun 19 at 16:07
  • Fair enough - the question states the behavior of what happens when the number ticks over the digits specified in the display format, is what I was getting at. The items below don't get at going higher than 10bn records either. – Thomas Taylor Jun 19 at 17:21

I just created a custom object using an Auto Number Display Format of T-{0} and names like T-10 and T-11 were created.

So looks like no restarting, with the formatting expanding as you might expect for the numbers that use more characters than specified by the format.


And there is this Salesforce Knowledge Article on the subject stolen from DerekF's comment: Effects when auto-number field exceeds the specified digits.

  • 3
    There's also an official help page that says that this is the expected behavior: help.salesforce.com/articleView?id=000338274&type=1 – Derek F Jun 19 at 16:24
  • Hi @DerekF that's probably a better answer - why don't you post that as an answer? – Keith C Jun 19 at 17:07
  • didn't find that page Derek before. Thank you both – user56320 Jun 20 at 15:58