>Will,
>
>Change the data type to character. That is unless it is important to calculate the average or standard deviation of the week number. It is easy enough to use VAL() and STR() to switch the data type for use in your code. The character data type will give much better control over how the data is displayed.

Ok thanks Jim

Not quite what I was after but at least it seems it can't be done with a numeric.