How do I keep Numbers from mangling numbers when importing a CSV?

When I open a CSV file in Numbers, it "helpfully" converts fields it recognizes as numeric by stripping leading zeros, converting things it recognizes as dates, etc. Take for example, you type a UPC code into a Numbers spreadsheet **005566778899**, Numbers will automatically convert that to **5566778899**. This is not what I would want... However, the way *I* use Numbers, I open databases with thousands of UPC codes with preceding zeroes. Some of them also contain **dates** which Numbers will also reformat. Basically I do not want any of these features, I want my content to be left alone. # How can I get Numbers to leave my data intact when I open a CSV file? *Converting the fields to text after importing won't help since the data was already messed with...*