Quote:
Originally posted by guest1
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 |
Seems to be all working now so fingers crossed and thanks again for all the info, much appreciated.