Hi guys,
So i am using this formula below to merge a cell with a day in (A1) and date in (B1) but i am getting " Tuesday 42969 " is there anyway round this?

=(A1&" "&B1)