Pasting in Numbers cell with tabs and returns

10-11  Source: Network gathering  Views:0 

I am converting my old Appleworks SS files to Numbers and it works fine when I just open the .cwk file with Numbers.  But when I try to paste in to a cell text with tabs and returns, unlike AW, it puts as much of the text as will fit in one cell, truncating the remainder.
Is there some way to change Numbers preferences (or any other technique) to push text separated with tabs to the next cell right and for returns to push to the next row?
I just figured out what I did wrong.  The text I was pasting in was enclosed in quote marks.  Once I removed those, it pasted in perfectly, just like AW.
Related articles