×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel is amalgamating numbers.

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

RE: Excel is amalgamating numbers.

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

RE: Excel is amalgamating numbers.

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.

RE: Excel is amalgamating numbers.

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

RE: Excel is amalgamating numbers.

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: Eng-Tips.com Forum Policies
Chinese prisoner wins Nobel Peace Prize

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources