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).
No comments:
Post a Comment