Excel VBA - cell format
Posted on 2004-04-29
I need to format the cell to be a date type
so far I am guessing I could use something like this string:
but this doesn't do anything in my excel. I am spitting out data from my ASP array into Excel and currently the dates are showing up in the wrong format. For example, one date shows 38089.52997
so I need to format that column of data after my export from ASP to Excel to be Date format in Excel.