G
Guest
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
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