Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there a way in Excel (2007 and up) to set the date format of a column to the date format of the OS locales. The data entered in this column is a date (imported from a database date field).

For example I enter 2003-01-02 00:00:00 (Jan 2nd 2003) I want to see 01/02/2003 00:00:00 in the USA and 02.01.2003 00:00:00 in Germany when I open my spreadsheet (without updating the column date format).

share|improve this question

If set up correctly, these can change with the regional settings of Windows. Here is an article from Excel Semi-Pro which explains it well. Regional Date Formats in Excel

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .