Excel format cells with quotes

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.