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
2006-06-17 10:56:44 · 5 answers · asked by ELIJAH 1 in Dining Out ➔ United States ➔ Seattle
I didn't think anyone still used works. It is very outdated and your question answers why no ever uses it anymore, let alone know that works and excel are 2 different things.
2006-06-19 09:26:01 · answer #1 · answered by Anonymous · 0⤊ 0⤋
you have stumbled throughout the time of a cellular delimiter. while a huge decision with thousand unit commas is transferred to Microsoft Works Spreadsheet (version 5.0) from yet another software that's no longer an MS software, it truly is examine as a delimiter set (?) The MWS reads each and each comma as a separate cellular set. If this technique you have been copying from replace into already a MS software (MSW spreadsheet or MS Excel) it may reproduction thoroughly into one cellular. (tried copying to Excel then to MSW Spreadsheet, it truly works) it truly is basically yet differently MS gets you to purchase their products. The Excel software has Import and Export so which you will commerce information with the likes of Lotus a million-2-3 etc. those little quirks are what upsets a great sort of persons with Microsoft (and different companies). no person needs to be compatible with yet another product. Sorry i could no longer help. the only way this could artwork is to delete the commas. cut back and paste your numbers into their respective cells and then format the cells with the loads unit commas. sturdy success.
2016-10-31 01:35:13 · answer #2 · answered by ? 4 · 0⤊ 0⤋
You probably have an older version of Excel.
You may have a newer version of Excel that recognizes imported data as having a column break with the periods. Look through your copy/paste options to see if there is a setting.
Otherwise it worked just fine on my Windows XP.
2006-06-19 06:06:50 · answer #3 · answered by Veritatum17 6 · 0⤊ 0⤋
try typing the apostrophe (') character before pasting.
2006-06-23 04:26:53 · answer #4 · answered by Squirrel 3 · 0⤊ 0⤋
1,333,333 ????? oh sorry
i did not understand
2006-06-17 11:11:31 · answer #5 · answered by Ginnykitty 7 · 0⤊ 0⤋