What dates are recognized by the local Excel settings? I would guess that
the big obstacle would be the month names/abbreviations. Perhaps you need to
convert them to strings, then use a lookup table to replace the month names
with the localized equivalents, then do the conversion using the DATEVALUE
function. Just a thought as I have no way to test it.
--
- K Dales


"Mika" wrote:

Hi,

I checked past post about date conversions but couldn't find any that
fix my problem:

- I am doing a query that returns dates (text strings) in the format 1
Dec 2005, and I need to convert them to the user short date format.

Problem is that the xl of those users does not understand "Dec". As
there are "built in" functions that only works in the American format I
was expecting this was going to be an easy one... but so far no
success. Ideas

Mika