View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How do I insert quotation marks to a list of numbers in a column?

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

(both work for double quotes)

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.


--

Dave Peterson