Time and Date on X axis

My bad. The formula was in C2.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

dvt wrote:
Jon Peltier wrote:

I put your data into columns A and B, formatted as text to simulate
the worst. I put this formula in B2 and filled it down:

=A2+B2


DataMan wrote:

You put the formula in B2?


I'll bet that was a typo on Jon's part. I'm quite sure he meant C2, not B2.

Dave
dvt at psu dot edu

The program that I use to pull the data from our SCADA system apparently
inserts a space character before the time. When pulling the csv file
into Excel it brings this same space character into the time column
that precedes every time entry.

Remove the space and the addition works. Yea!

I will play with this at work Monday and see what I can do to remove
the spaces before doing the math.

One thought. This space character has never triped up Excel 97 before.
I wonder whats up with that?

Thanks for all the help. I will let you know how it goes.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

In Excel 97, the axis labels were set up as text labels, without any
numerical interpretation. The problem is trying to turn text into
numerical values, and nonnumeric characters throw off the conversion.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

DataMan wrote:
The program that I use to pull the data from our SCADA system apparently
inserts a space character before the time. When pulling the csv file
into Excel it brings this same space character into the time column
that precedes every time entry.

Remove the space and the addition works. Yea!

I will play with this at work Monday and see what I can do to remove
the spaces before doing the math.

One thought. This space character has never triped up Excel 97 before.
I wonder whats up with that?

Thanks for all the help. I will let you know how it goes.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/