openoffice

I had this strange problem importing a regular .csv file into Openoffice.
A field in the file would not be recognized as a number, no matter what I would do during the import process.
This happened chossing ‘Sheet from file’ as well as cutting and pasting into a sheet.
The ‘ is not visible into a cell but is present only in the formula field.
A simple find and replace will not help. Nor it will help setting a the cell format via Format Cell