Excel is amalgamating numbers.

[schnell]

Hello,

I am wanting my comma separated list of variables from my application to go into an excel document ...

When pasted into a cell, excl just makes it into one number.

This does not happen with any other list of numbers used.

Here is the list.........


370,455,535,610,680,730,810,885,965


Here is a good list of numbers.......it works ok for these........

370,475,560,630,680,715,760,820,910,1010,1095

 

[satchmo]

Try Paste Special, then paste as Unicode Text. That worked for me in Excel 2007.

 

[JBinCA]

Try pasting from your application into a text editor first. Notepad for example. Then copy from notepad and paste to excel.

Or save the notepad doc as yourfilename.csv and open it with excel.

 

[zdas04]

I just pasted the first one and it gave me a single, very big number. Then I went (in Excel 2007, other vervsions have this concept other places) into "Data" "Text to Columns" and said the field was delimited and checked the "comma" box.

That didn't fix the cell, but then I grabbed the strings again and used "paste special" and picked "text" and it parsed both strings perfectly.

It acted like the html to text process needed to be taught that a comma was a data element separator instead of a thousands separator.

David

 

[IRstuff]

Sure, obviously, the difference is that the 2nd sequence has 4 digit numbers.

Pasting as unicode didn't work in my version, but these worked.

> save as .csv file in a text editor, and open the file
> reformat to have spaces after the commas
> reformat to have leading zeros, Paste Special as text

If your output is from a program that you have some control over, you might be able to get it to format the data automatically

TTFN

FAQ731-376
Chinese prisoner wins Nobel Peace Prize