Forum Discussion
Change Date Format
How can I change the date format from dd.mm.yyyy (as is the standard in New Zealand) to yyyy.mm.dd - This spreadsheet has over 1300 row ( and numerous columns) of data.
Keith_Morrison If the column contains real dates, not just texts looking like dates", you can apply a custom format. If they are texts you need to transform them to real dates first. Date in Excel are in fact sequential numbers starting at 1 on January 1, 1900. You can use ISNUMBER to check if the "dates" are indeed numbers.