Home
CSV Format As Text No Matter What
To create a plain text CSV and force Excel to treat everything within as text is helpful. You could have commas in the fields, you could have some other weird stuff. For each cell
"= ""YOUR DATA"""
So that's quote equals space quote quote YOUR DATA quote quote quote.
Complex but it works. Lord only knows why but these are the mysteries of Microsoft.
In C#
MyString = "\"= \"\" + MyDateVariable + "\"\"\"";
Reader's Comments
Name
Comment
Add a RELEVANT link (not required)
Upload an image (not required)
Uploading...
Home