Formatting Merged Date and Time

[sizemic1]

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

[jasoncw]

Hi, Paul.

Did you try adding the 2 columns together, rather than concatenate?

Jason

[sizemic1]

Tried that.

It's something to do with the date and/or time formatting.

If I start a new workbook and manually type in 10/13/07 and 12:00:00 and then add them together, I get 10/13/07 12:00:00

However, If I copy and paste or paste special (values only) and then try to add them together in my new workbook I get #VALUE!

[sizemic1]

Figured it out.

There was a space before my time value _12:00:00
Find and replace took care of that.
Now I just gotta get this stuff to graph correctly and i'll be good to go!