Forum Discussion
Date format not getting captured
Do you want to store real dates in Excel or just texts? If the latter, format the destination column as Text before you Paste Special, Text.
Excel indeed tries to create dates for you, as it has great advantages when doing further work in Excel. Once the real date is stored in Excel you can display it in any way you like. So when you see 01/09/2022 in the formula bar, Excel has actually stored is as day number 44805 (day number 1 being 1 Jan 1900) and used your system settings to show that format in the formula bar. Use custom a format like
dd mmm yyyy to display the date as 02 Sep 2022 .
Working with real dates enables you to calculate with them (e.g. duration) and use Excel's built-in time intelligence to create summaries by week, month, quarter, year, from-to etc.