Here is how to format a text cell so it will have either double or single quotes. I needed to import a csv file with text fields formatted with double quotes. There are probably some more reasons why you might need to do this.
- Edit the cell or column you need to format
- choose format cell
- Select Custom from the bottom
- use the formula \"@\"
The @ symbol represents the text in the field. You can wrap any text field with any character but make sure to escape it.