Eike Rathke wrote: >> Both return the same ISO date-string of a number in A1. >> Can I take English format codes for granted with all locales? > > Yes, for the TEXT function English date format codes do work with all > locales. >
Sorry, I found an inconsistancy with this feature: =TEXT(A1;"YYYY-MM-DD") works just fine =TEXT(A1;"YYYY-MM-DD HH:MM:SS") returns "YYYY-03-DD 08:17:40" It needs to be =TEXT(A1;"JJJJ-MM-TT HH:MM:SS") with German locale. May I file an issue? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]