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

Post Your Comment Posts/Links Rules

Name

Comment

Add a RELEVANT link (not required)

Upload an image (not required)

No uploaded image
Real person number
Please enter the above number below




Home
Admin Ren's Biking Blog