How do I create a custom number format in excel that ends with a letter?

I created a video to do something like this, I hope it helps!

https://www.youtube.com/watch?v=uXxw0INlFqc

List and discussion of different number format codes (FWIW, this was one of my most used help files when I was learning Excel): https://support.office.com/en-au/art...2-09fab54be7f4

The very first section describes how to include numbers and text in number format codes. See if that helps.

PS. I sometimes find that I confuse myself when I use number formatting to add text to a number like this, because what I see in the cell (555-55-5555a) is so different from the underlying value (555555555) that I sometimes get confused. If you find this to be true for you, as well, it may be preferable to use easyexcelanswers' "concatenate" solution so that the cell's value is the same as the displayed text string.

Originally Posted by guitarteacher

I can not get it to add a random letter like a, b, d and so on.

Do you want to specify the letter, or do you want a random letter?

If the former, personally I would use this custom format: 000-00-0000"a" (replace the "a" with whatever letter you want, keeping the quotation marks). However, you could use the already-suggested concatenate method instead if you want.

If the latter, then concatenate is the only way of doing it. If your list of numbers is in column A, starting in A1, put this in B1 and drag down:

Formula:

Please Login or Register  to view this content.

This will convert 123456789 to 123-45-6789x with x being any lower case letter from a to z - if you want upper case A to Z use (65,90) instead of (97,122).