Stop Excel from automatically converting certain text values to dates

by

I have found that putting an ‘=’ before the double quotes will accomplish what you want. It forces the data to be text.

eg. =”2008-10-03″,=”more text”

EDIT (according to other posts): because of the Excel 2007 bug noted by Jeffiekins one should use the solution proposed by Andrew: "=""2008-10-03"""

More Related Contents:

  1. Is it possible to force Excel recognize UTF-8 CSV files automatically?
  2. Microsoft Excel mangles Diacritics in .csv files?
  3. Excel to CSV with UTF8 encoding [closed]
  4. Excel CSV – Number cell format
  5. Generating CSV file for Excel, how to have a newline inside a value
  6. Export hashtable to CSV with the key as the column heading
  7. Save each sheet in a workbook to separate CSV files
  8. Export each sheet to a separate csv file
  9. How to correctly display .csv files within Excel 2013?
  10. How can I import an Excel file into SQL Server? [closed]
  11. Convert xlsx file to csv using batch
  12. Importing CSV with line breaks in Excel 2007
  13. How do I use awk under cygwin to print fields from an excel spreadsheet?
  14. converting an Excel (xls) file to a comma separated (csv) file without the GUI
  15. sep=”;” statement breaks utf8 BOM in CSV file which is generated by XSL
  16. How to save excel columns with long numbers into csv?
  17. Importing Excel spreadsheet data into another Excel spreadsheet containing VBA
  18. Can Excel interpret the URLs in my CSV as hyperlinks?
  19. Format Cell Contents
  20. Excel formula checklist in employees
  21. import csv file to sql database in c# window application without header row [duplicate]
  22. How do I put double quotes in a string in vba?
  23. How to insert an embedded picture?
  24. Obtain attribute names from XML using VBA
  25. Paste Excel range in Outlook
  26. Run-time error ‘1004’ : Method ‘Range’ of object’_Global’ failed
  27. Export chart as image – with click of a button
  28. Error13 in Excel VBA in data file
  29. Excel cell from which a Function is called [duplicate]
  30. How to extract text within a string of text

Leave a Comment