Excel 2003

Hi James

Sorry for the delay in answering this question.

In Excel when you enter a Word/number combination (e.g. Week1) and copy this down by dragging, as a default, the system does a Series copy.

This automatically increases the number in the statement by 1.

To be able to copy only the value with no numeric increase:

After the copy a Auto Fill Options box appears next to the last cell of the copy range.

Click the box

You should find Fill Series selected

Select Copy Cells.

The data should lose the number increments and revert to the value in the original cell

Hope this helps

Carlos