Thanks for reading this post.

How can I CUSTOM format a cell to have the the text USD/TT/2008/ precede the
number entered in the cell.

eg.
Number entered is 0001; required format is USD/TT/2008/0001

Is their any way I could further improve on this. For instance in cell Aa if
USD is entered the format in cell B1 should be USD/TT/2008/0001 and if GBP is
entered it should be GBP/TT/2008/0016 and so on (0001 and 0016 are variables
entered manually).

Regards

Preman