Use your favourite spreadsheet app on both platforms without fear.
The conversion to CSV compatible format follows these rules: A string is enclosed in double quotes if it contains a double quote, comma, or spans multiple lines Each double quote within a string is converted to two double quotes.
Each field is comma separated and has quotation marks around the value in the field. Multiple single text values each on one line converted to multiple CSV strings. csv files if the field contains a number. The best solution I can think of is wrapping the value in quote marks on the CSV but I cant figure out how to do that. All you wanted to know about Microsoft Excel on Mac is here! Learn what basic modifications this version of Excel has and what is missing in comparison with Windows version. Double-click the Fill Handle and Excel will shoot the formula down to B50000. Excel is stripping off quotation marks from.
