9
2
When I paste a date into Excel 2010 in the format "2012-12-07 00:00:00.000" I'd like it to be displayed by default as "2012-12-07", but it is actually displayed as "00:00.0".
I know I can work around this by prepending a ' or changing the cell format, but I'm interested in changing the default format.
An approach that almost works is going to Control Panel->Region and Language->Long Time format and changing it to something like "h". This results in Excel displaying the dates I paste in as "2012-12-07 00:00:00.000", but screws up times displayed outside of Excel.
The dates I'm pasting in are from SQL Server.
5A column using the date format won't show some non-date values correctly, so I don't see how this approach could work. EG, if I set column A to always use date format my dates would show up correctly but not numbers. And dates pasted into column B would still be displayed incorrectly. – RossFabricant – 2012-12-07T17:21:55.290
@RossFabricant you are correct, however excel's default formatting for all cells is general, which means the excel will guess the data type based on what you enter. I don't know of any interface in excel that allows these guesses to be customized. – Pynner – 2012-12-09T20:34:41.867
4It's nice you're trying to provide a workaround, but this doesn't really answer the OP's question. – Kenny Evitt – 2013-07-12T13:19:18.587