shanedavid1981
Programmer
Hi everyone,
I seem to have an ongoing problem...
If I get a report from a cgi page into excel (for importing into access), and the cgi page contains dates in american format (mm/dd/yyyy), excel will try and use mm/dd/yyyy as dd/mm/yyyy, rather than change them all around.
So, put simply, the date 03/05/2005 from the cgi (5th March, 2005) translates into excel as 05/03/2005 correctly, but then reads as 3rd May, 2005.
So when I get dates like 03/13/2005 excel doesn't touch it as it's not immediately readable as a date.
Is there a function somewhere I can use to check all the dates and turn them all around to british format?
This has been driving me mad for months. I have tried all ways around it I can think of, changing system locales, excel locales and everything inbetween...
Thanks
I seem to have an ongoing problem...
If I get a report from a cgi page into excel (for importing into access), and the cgi page contains dates in american format (mm/dd/yyyy), excel will try and use mm/dd/yyyy as dd/mm/yyyy, rather than change them all around.
So, put simply, the date 03/05/2005 from the cgi (5th March, 2005) translates into excel as 05/03/2005 correctly, but then reads as 3rd May, 2005.
So when I get dates like 03/13/2005 excel doesn't touch it as it's not immediately readable as a date.
Is there a function somewhere I can use to check all the dates and turn them all around to british format?
This has been driving me mad for months. I have tried all ways around it I can think of, changing system locales, excel locales and everything inbetween...
Thanks