I put it into notepad.
did the import and it is still putting it into the same format I put
into notepad.
it is wrapping at IV....the same 255 limit i had in the originail
file.
will try some more.



On Fri, 21 Oct 2011 05:17:35 -0700 (PDT), Andrew
wrote:

On Oct 21, 5:56Â*am, sparks wrote:
This is what is weird...I guess its backwards compatibility or
something.

the file is an xlsx but it is wrapping at IV I guess for excel 97 so
we checked and it has about 8000 time values...can the newer excel go
that high?

we end up with a single sheet that looks like this (quick cut and
paste not what we have) over and over until the end of its time cycle.

10/17/2011 4:24:20 4:24:35 4:24:50 4:25:05 4:25:20
BOB1 Â* Â* Â* 125 Â* Â* 122 Â* Â* 120 Â* Â* 123 Â* Â* 111
BOB2 Â* Â* Â* 0 Â* Â* Â* 0 Â* Â* Â* 0 Â* Â* Â* 0 Â* Â* Â* 0
BOB3 Â* Â* Â* Â* Â* Â* Â* Â* Â* Â*0 Â*0 Â* Â* Â* 0 Â* Â* Â* 0 Â* Â* Â* -0.1I
10/17/2011 4:24:20 4:24:35 4:24:50 4:25:05 4:25:20
BOB1 Â* Â* Â* 125 Â* Â* 122 Â* Â* 120 Â* Â* 123 Â* Â* 111
BOB2 Â* Â* Â* 0 Â* Â* Â* 0 Â* Â* Â* 0 Â* Â* Â* 0 Â* Â* Â* 0
BOB3 Â* Â* Â* Â* Â* Â* Â* Â* Â* Â*0 Â*0 Â* Â* Â* 0 Â* Â* Â* 0 Â* Â* Â* -0.1I
10/17/2011 4:24:20 4:24:35 4:24:50 4:25:05 4:25:20
BOB1 Â* Â* Â* 125 Â* Â* 122 Â* Â* 120 Â* Â* 123 Â* Â* 111
BOB2 Â* Â* Â* 0 Â* Â* Â* 0 Â* Â* Â* 0 Â* Â* Â* 0 Â* Â* Â* 0
BOB3 Â* Â* Â* Â* Â* Â* Â* Â* Â* Â*0 Â*0 Â* Â* Â* 0 Â* Â* Â* 0 Â* Â* Â* -0.1I

IF it was a single row of data a quick transpose and we are done.

Copy your excel sheet into notepad. Then in excel, import the data
from text. Don't try to copy and paste. Use the data import function
which is under the data tab. Then once the import begins, import as
"delimited", using a space for the delimiter.