Excel is amalgamating numbers.
Excel is amalgamating numbers.
(OP)
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
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





RE: Excel is amalgamating numbers.
RE: Excel is amalgamating numbers.
Or save the notepad doc as yourfilename.csv and open it with excel.
RE: Excel is amalgamating numbers.
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
RE: Excel is amalgamating 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: Eng-Tips.com Forum Policies
Chinese prisoner wins Nobel Peace Prize