This question already has an answer here:
I'm working on a script that outputs data to .CSV format, but when these files are loaded into Excel, Excel will often re-format the data a specific way.
might be read into Excel and displayed by default as:
"115" "5.50%" and "01/01/08"
Is there any way, within the format of a CSV to tell Excel to leave the data as-is and not interpret it as a specific data type? Actually I would like the ability to have Excel recognize certain numeric fields and right justify them, but not necessarily add decimals or change the date display format. Any alternatives?