Skip to main content

All Questions

135 votes
6 answers
327k views

Formatting a comma-delimited CSV to force Excel to interpret value as a string

I've been searching around for a while trying to figure out how to output a CSV file in such a way to force Excel to interpret the values as a string and not try to convert them to numbers or dates. ...
Simon E.'s user avatar
  • 4,174
0 votes
2 answers
753 views

What is going wrong with importing and formatting the following .csv data set into Excel?

I'm trying to import the following CSV data set into Excel. I'm using the Text Import Wizard to set the right delimiters. So far, I used the ";" and "," delimiters. Here is the ...
Max Muller's user avatar