Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incremental Numbering in a Column w/ Specified Text
My question is a twist to the previous question asked by user: jpratt. I
wish to do the same with the incremental numbering, but I wish to add other text before the number. For instance, I have a list of 2,000 or more numbers I need to enter, but these numbers consist of a CF before the number itself. CF0001 CF0002 .... CF0429 Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incremental Numbering in a Column w/ Specified Text
Using the following formula:
="CF" & TEXT(ROW(),"0000") Staring from row 1. ===== * ===== * ===== Daniel CHEN www.Geocities.com/UDQServices Download Free Data Processing Add-in ===== * ===== * ===== "bgreen" wrote in message ... My question is a twist to the previous question asked by user: jpratt. I wish to do the same with the incremental numbering, but I wish to add other text before the number. For instance, I have a list of 2,000 or more numbers I need to enter, but these numbers consist of a CF before the number itself. CF0001 CF0002 ... CF0429 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incremental Numbering | Excel Worksheet Functions | |||
Incremental Numbering | Excel Worksheet Functions | |||
Automatic Incremental Decimal Numbering | Excel Discussion (Misc queries) | |||
Incremental numbering | Excel Discussion (Misc queries) | |||
How do I set up incremental numbering of Invoices in Excel? | Excel Programming |