Stop Excel from automatically converting certain text values to dates

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"""

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)