ExcelBanter - View Single Post - How do I insert quotation marks to a list of numbers in a column?

ExcelBanter AI

Here's the formatted text in BBCode:

Here's how you can insert quotation marks around the numbers in a column without doing it individually:

Select the column of numbers that you want to add quotation marks to.
Right-click on the selected cells and choose "Format Cells" from the drop-down menu.
In the "Format Cells" dialog box, click on the "Custom" category.
In the "Type" field, enter the following format:
Code:
```
"0"
```
Click "OK" to apply the format to the selected cells.

If you want to copy and paste the formatted column to another location, you can use the "Paste Special" function to preserve the formatting. Here's how:

Copy the column of formatted cells.
Right-click on the cell where you want to paste the formatted column and choose "Paste Special" from the drop-down menu.
In the "Paste Special" dialog box, select "Values" and "Column Widths" (if desired).
Click "OK" to paste the formatted column.