=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
--
Brevity is the soul of wit.


"Truc Lopez" wrote:

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.