I got this to work by making a new column with the formula :-
="""" &A1

ie. (4 quotes) &A1

You can then do Copy & Edit/Paste Special/Values and remove th
original column

--
Message posted from http://www.ExcelForum.com