Quickly insert a unique (and consecutive) value into a cell in Excel. You can add text prefix or suffix and specify the number of digits for the number. For example, you can easily insert a series number as Kutools-XXXX-2011 (XXXX indicates the sequence number). Fill Custom Lists. UVHUP & The Holodome Onslaught. 364 Handsome Jack Doppelganger Pack. 523 Borderlands: The Pre-Sequel Season Pass.
Ken wrote: It may sound odd, but some account numbers actually start with the number '0' (i.e. However, Excel will not allow this; Excel removes the zero. How do I format the cell to accept the zero, to allow the entry 01234567 exactly as I enter it? It you want to enter it as a number, format the cell with the Custom format 00000000, where there are as many zeros as there might be in the account number. However, beware that Excel will only interpret account numbers up to 15 digits correctly in this way. It would be more reliable for you to enter the account number as text.
How you do that depends on exactly how you inputing the numbers in the first place. If you are typing them in manually, prefix the account number with an apostrophe (aka single-quote). For example, '01234567. Alternatively, format the cells as Text before you enter the data. If you are inputting the data from CSV or TXT file, or if you are copying them and pasting into Excel, you might be able to use the appropriate 'wizard' to cause a column of account numbers to be treated as text.
If that is unclear, please post specifics.