View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
joeycalisay joeycalisay is offline
external usenet poster
 
Posts: 7
Default removing single quotes from a paste operation

i have noticed that when data being pasted to an excel worksheet have
single quotes on all cells, it is being retained by excel. i just
want excel to treat all data as text. anyway to force excel to render
each cells without the single quotes?