Generating Report Numbers

Hi all,

I am wondering if there is a way to generate specific Report Numbers that must contain a constant.

I have two different sets of numbers that I would need to generate, below is an example of the numbers but I'm wondering if Excel could do this automatically?

The first is:

G_YY_001
G_YY_002
G_YY_003

The second is:

D_YY_001
D_YY_002
D_YY_003



If it is possible to take it further, instead of "YY" in each number, could Excel automatically have the year, as in for this year "YY" = "13"



Thanks,

Alex

Thank you very much, I don't know why I didn't think of that!