Hi Marcol,
thanks for the speedy reply. I actually deleted the column and created a new one further on, then repeated the formula and it worked..
Cheers again it is appreciated.