Graham C1600
Board Regular
- Joined
- Feb 17, 2018
- Messages
- 96
- Office Version
- 365
Hi,
I'm currently using data from 1 excel sheet and then moving it to another sheet using the &" "& option. Something like detailed below :-
<tbody>
</tbody>
I then use this information and move it to another sheet but put the text from all 4 cells into 1 cell by typing the following into the required cell on the new sheet:-
=A1&" "&B1&" "&C1&" "&D1
The only issue with doing this is that is provides something like the following back in the new cell (Start date 32456 End date 34512)]
So obviously when pulling the information across the date is changing into the numbers.
Is there a way of stopping this happening so the actual dates will be displayed instead of numbers ?
Thanks
I'm currently using data from 1 excel sheet and then moving it to another sheet using the &" "& option. Something like detailed below :-
A | B | C | D | |
1 | Start date | 05/05/2018 | End date | 15/05/2018 |
<tbody>
</tbody>
I then use this information and move it to another sheet but put the text from all 4 cells into 1 cell by typing the following into the required cell on the new sheet:-
=A1&" "&B1&" "&C1&" "&D1
The only issue with doing this is that is provides something like the following back in the new cell (Start date 32456 End date 34512)]
So obviously when pulling the information across the date is changing into the numbers.
Is there a way of stopping this happening so the actual dates will be displayed instead of numbers ?
Thanks