- Local time
- Tomorrow, 01:10
- Joined
- Jan 20, 2009
- Messages
- 12,853
When pasting data from SQL Server query results into Excel, dates always become formatted as Time even when the column has already been explicitly formatted as Date.
Office applications can make some really dumb decisions trying to second guess what is required but this one is ridiculous. The pasted dates don't even have a Time component so they all display as 00:00:00. So why override the column's predefined Date format to Time? Meanwhile values that are quite obviously numbers will be presented as dates if pasted into a preformatted Date column. Why not override them?
Date columns in the SQL results can be formatted to just be just a date but then Excel decides it is text despite looking exactly like dates.
Anyone know how to avoid this nonsense?
Office applications can make some really dumb decisions trying to second guess what is required but this one is ridiculous. The pasted dates don't even have a Time component so they all display as 00:00:00. So why override the column's predefined Date format to Time? Meanwhile values that are quite obviously numbers will be presented as dates if pasted into a preformatted Date column. Why not override them?
Date columns in the SQL results can be formatted to just be just a date but then Excel decides it is text despite looking exactly like dates.
Anyone know how to avoid this nonsense?