Thanks Brian,
This exactly how I solved it.
But cumbersome given that DATEVALUE seems to be intended to do just
this.
Thanks,
Ferry
Brian Barker schreef op ma 05-03-2012 om 00:32 [+]:
At 22:35 04/03/2012 +0100, Ferry Toth wrote:
With the dutch localization DATEVALUE accepts 1-jan-2011
Am 04.03.2012 22:35, Ferry Toth wrote:
Couldn't datavalue take the locale of the formatted cell?
Or is there a better trick to ge this done?
The same probably holds for other localized conversions as well.
Ferry
Convert the text to number using the appropriate formulas and locale.