How do I insert quotation marks to a list of numbers in a column?

[Truc Lopez]

I have a list of numbers in a column. I want to insert quotation marks
around the numbers. How do I do this without inserting them individually?
Thank you in advance for your help.

 

[Dave F]

=CONCATENATE("'",A1,"'")

Note there is a single quotation mark, ' , between the double quotation
marks in the formula I give above. If you want double quotation marks to
appear, then replace the single quotation mark with a double quotation mark.

Dave

 

[Dave Peterson]

or
=""""&A1&""""
or
=char(34)&a1&char(34)

(both work for double quotes)

 

[ExcelJockey]

yet another way is the define a custom cell format (righ
click->format cell->number->custom

\"#,##0\";[Red]\"#,##0\

which you can apply to a range of cells once defined

the quotation mark cannot be entered directly into the custom forma
field. you must insert it as a special symbol (0022) into a blan
field of your worksheet and then copy and paste that into you
definition. in case copy and paste gets flakey, once you have on
quotation mark in the format definition field, you can copy and past
that one into the remainder of the formula rather than start over b
going back to the cell in the worksheet

 

[Dave Peterson]

I could pick up your formatting string and paste it directly into the Type box
on that custom format dialog.

Note to the original poster:

This doesn't actually change the value--it just changes the appearance in the
cell. (Not sure if that's important though.)

yet another way is the define a custom cell format (right
click->format cell->number->custom)

\"#,##0\";[Red]\"#,##0\"

which you can apply to a range of cells once defined.

the quotation mark cannot be entered directly into the custom format
field. you must insert it as a special symbol (0022) into a blank
field of your worksheet and then copy and paste that into your
definition. in case copy and paste gets flakey, once you have one
quotation mark in the format definition field, you can copy and paste
that one into the remainder of the formula rather than start over by
going back to the cell in the worksheet.