If I copy and paste a column of numbers that include commas (e.g. $3,000,000,000), WORKS will split up the number in different colunms. Try it. How do I adjust WORKS spreadsheet to ignore commas as delimiters?
2006-06-16 02:20:53 · 3 answers · asked by Kinloch K 1 in Computers & Internet ➔ Programming & Design
Make sure source works. and destination s.has cells selected as numbers. I assume you know how to do it. But here it is in case:
Select column. Right click it and go to format cells.Stay in number tab and select number.
It should work fine.
2006-06-16 02:31:30 · answer #1 · answered by cutegirl 1 · 0⤊ 0⤋
(1) Filter out the commas. If you understand grep or regular expressions it's a piece of cake. If you don't, it may still be possible with regular search-and-replace. It depends on the file format.
(2) Use a macro to reassemble the split columns back into numbers in the spreadsheet. Again, this may be simple or not, depending on the other data in the file.
2006-06-27 18:57:21 · answer #2 · answered by poorcocoboiboi 6 · 0⤊ 0⤋
Just don't put the commas.
2006-06-25 17:59:19 · answer #3 · answered by _anonymous_ 4 · 0⤊ 0⤋