Hi,
I'm having bit of an issue here, in cell A1 I have text, then in B1 a date in dd/mm/yyyy format, then in C1 text and date in the same format in D1.
When I join the cells i.e =A1&B1&C1&D1 it returns a number for the date? I have tried to change the date to a number format and then changed the formula cell to a date format but it still doesnt work.
Any ideas?
I'm having bit of an issue here, in cell A1 I have text, then in B1 a date in dd/mm/yyyy format, then in C1 text and date in the same format in D1.
When I join the cells i.e =A1&B1&C1&D1 it returns a number for the date? I have tried to change the date to a number format and then changed the formula cell to a date format but it still doesnt work.
Any ideas?