Hi all.
I've done a search and haven't come up with the answer I need, so hopefully someone can help.
I've imported a CSV file that has 230 rows.
Column A: has a Date MM/DD/YY
Column B: has a time 00:00:00
Column C: has data I want to graph over time
I would like to merge columns A & B together so that I get MM/DD/YY 00:00:00.
I've used the concatenate function, however I'm having problems.
For example.
Sample Data
12/10/07 00:00:00 1
12/10/07 06:00:00 2
12/10/07 12:00:00 67
12/10/07 18:00:00 90
Concatenating 12/10/07 with 12:00:00 results in 39425 12:00:00
How can I get this to display correctly?
It needs to be in the correct format so that the X Axis of a line chart shows the actual date and time and not the 39425 number and time.
Thanks for the help!
-Paul
Bookmarks