Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.