1

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).

Improve this question

1 Answer 1

Reset to default
0

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

Improve this answer

You must log in to answer this question.

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