Re: Fixing a date going to Excel

On Thu, 07 Jun 2012 13:53:34 -0700, Pat Barber <mboceanside@xxxxxxx>
wrote:

In the last few weeks I was looking for a solution to create a
csv file that would end up in a spreadsheet.

For me putting a date in a CSV file in the format "6/07/2012" (for
today) gets interpreted by Excel as a date. I don't know if the
quotes are required for it to work.

I put quotes around everything that isn't meant to be a number, even
if it is a character string that just happens to contain all numbers.
Of course, as Dennis pointed out, Micro$oft in their infinite wisdom
decided that these should be treated as numbers anyway. :(

Ken
Opinions expressed are my own and do not necessarily represent the views
of my employer or anyone in their right mind.