I have used the "concatenate" function to put together data from 4 separate
columns to form a date & time entry in the next column (the original 4
columns came from a .cvs file) on the basis of dd/mm/yyyy hh:mm format.
I have defined the destimation column for 'Custom' Cell Format using the
dd/mm/yyyy hh:mm choice. But Excel does not recognise the information as
date & time, BUT, if I press the Return Key on each individual cell, then
Excel does recognise the contents as a date & time. Then I can go on to
chart my results on a timeline (the whole purpose of the exercise).
The difficulty is that I have 5000 entries with more to add. I don't want
to have to hit the Return key for every indivual cell as this defeats the
purpose of mass copy & paste.
How can I get Excel to accept the concatenated data as a date & time?