Paul, use of formatting can extend to dates as text. I'll speak in excel cell terms a table with three columns, starting at C5. Cell C5 - enter the date, format the cell as custom with ddmmyy C5 should now say 030406 Cell D5 - enter the number 1, format the cell as custom with 00 Cell D5 should now say 01 Formatting of these two cells is pretty irrelevant really because our formatting will take place in the result cell E5 Cell E5 - enter the following formula: =TEXT(C5,"ddmmyy")&TEXT(D5,"00") Cell E5 should now contain the text 03040601 Should now be a case of just copying the relevant rows down as far as you need and adding your own formulas. e,g, Cells C6 to C100 enter formula =$C$5 Cell D6 enter = D5+1 And just drag down the E cell formulas. If you get stuck send us a u2u |