I'm having problems concatenating a text formatted cell with a date formatted cell. Each time that I try to concatenate the 2n cells the date reverts back to the code e.g. 37305 rather than retaining the date format 19/01/02. Does anyone have any ideas to get around this.
Thanks
Matt
Thanks
Matt