Hi,
One solution can be to multiply all the text dates by 1. This can be
included in VBA macro code and can be achieved after export of data in
Excel.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 1100
Try looking at the DATEVALUE function in Excel.
On Fri, Oct 30, 2009 at 8:00 AM, manni...@nationwide.com <
manni...@nationwide.com> wrote:
>
> I'm using a access macro to export access crosstab query results to
> excel. Everything works
> great, except that the column names are dates that expor
I believe your problem is that in the Access database,
the field that has the date is really set up as a TEXT field.
the values only LOOKS like a date.
When the data is exported to excel, Excel assumes that
if the column is a text format, then it'll display it as text.
I have several of these.
I
