Formatting dates with different regional settings

D

Dirk

I need to convert the current date into text and use the
following function:

TEXT(NOW()," DDMMMYYYY hh:mm")

Unfortunately the spreadsheet will be used in countries
with different regional settings. In Germany for example
we would have to use TEXT(NOW()," TTMMMJJJJ hh:mm") to
get the same result.

Is there a way to make my date format independent from the
regional settings? Is there a universal date format? Or
can I find out what the regional settings are and format
my date conditionally?

Thanks for your help.

Dirk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top