Oops, this part below should have appeared in the post as:
.. And then put in A4 :
=IF($A$1="","",LEFT($A$1,LEN($A$1)-2)&TEXT(ROW(A1),"00"))
Copy A4 down to say A6
(The last line got wrapped around to the formula line)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--