View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Briankwei1234567 Briankwei1234567 is offline
external usenet poster
 
Posts: 1
Default excel save as csv quotation mark

Hi, I am trying to save a single worksheet from .xls to .csv format. The
worksheet contains dates, strings and numbers.

I would like to open the .csv file in wordpad and have quotation around
the strings. However, the trouble arises when I saved the .xls to .csv
format,
1.without using quotations (before saving) would produce a results of no
quotations
2.with quotations around the strings (before saving) would produce a result
of triple quotation marks.

My eventual goal is to simply have a single quotation mark around the
string, and dates (not the numbers). What can I do?

Thank you for your time,
Brian