in reply to Printing long number into file
I had a situation where I was doing a very similar thing, and my consumers (who were picking up the CSV file in Internet Explorer) were reporting this problem. They did not want to have to go into Excel's "Format Cell..." dialogue. Eventually I changed the format of the generated date/timestamp in the CSV file to "2008-02-25 16:55" (complete with the quotes) , Excel was happy, users were happy, I was happy ;-)
|
|---|