I have entered the first column to be automatic days of the year 1-Jan to 31-Dec automatically so when referencing them it turns to the number code, e.g. 39448 for Jan 1, 2008. Since I want to use the cancantnate function just on the text '1-Jan' this isn't working. Any ideas to fix this?