Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Single quotation mark in Excel not showing up | Excel Discussion (Misc queries) | |||
Save Excel file to CSV with quotation mark data delimeter? | Excel Discussion (Misc queries) | |||
Single Quotation mark in CSV | Excel Discussion (Misc queries) | |||
Excel CSV file: How to preserve double quotation mark on Unix ftp? | Excel Discussion (Misc queries) | |||
chr() for quotation mark | Excel Programming |