Monday 30 September 2019

Show date format in Excel as the OS default

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

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...