From here, copy and paste 1,333,333 on Microsoft Works Speadsheet into one cell. How possible?

Question

If you try it on Microsoft Works Speadsheet, it breaks the number up into 3 cells. I do not want to delete the commas before I copy and paste. If I did, it would work. If I had EXCEL speadsheet, no problem. Excel Spreadsheet places 1,333,333 into one cell as required.

Answer 1

Buy Excel. You can get a student-teacher version of the whole Office package for pretty cheap. Just make sure to wear sunglasses and look real stupid and they'll surely assume you're a student or teacher.

Otherwise, it seems impossible. I haven't used Works too often, but I tried a bunch of stuff just now and can't come up with anything good. I'm guessing they've got it built-in to use commas to separate the fields. That really should be an option.

If you're really desperate and don't want to pay for the Office package, you could use this simple formula to do it. Assuming you had pasted the number into cell A1, you could recombine the three cells into cell A4 with:
=A1*1000000+B1*1000+C1

This wouldn't be efficient unless you had a whole column of these screwed-up numbers. But if you did, it would fix your problem. And if the number wasn't always seven digits long, it wouldn't be too difficult to create a more sophisticated formula that would always work. If you don't know how to do that, send me an email and I'll write it for you. But again, it'd just be easier to get the cheapie Office version, or simply do it the long way. But I guess that's why they make Works so deficient.

Answer 2

ok this might work. when you press copy don't do a direct paste do edit-paste special and choose unformated text and i think it should because im not 100% sure.