Thanks I sometimes have users on Japanese systems.
Is there a nice workaround for that problem ?
Lars
On May 28, 10:03*pm, "Ron de Bruin" wrote:
Look out if you also use Non English systems if you use the Text function

yyyy in the Netherlands is *jjjj

English language Version entry:
="Today is "&TEXT(TODAY(),"yyyy-mm-dd")

In English language version the formula returns:
Today is 2005-02-23

Fails when the when workbook is open in Dutch language version (year = jaar "jjjj-mm-dd").
With a Dutch language version the formula will return:
Today is yyyy-02-23

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Lars Schouw" wrote in ...
Thanks Ron,

=TEXT(TODAY(),"yyyy.mm.dd")

seems to do the stunt..

I need this format since some application have depends on it.. I agree
ISO format is much nicer,- Hide quoted text -

- Show quoted text -