How can I change the default date format?

Posted by RossFabricant on Super User See other posts from Super User or by RossFabricant
Published on 2012-12-07T15:17:43Z Indexed on 2012/12/07 17:12 UTC
Read the original article Hit count: 185

Filed under:

excel-2010

|

format

|

date

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.

© Super User or respective owner

Related posts about excel-2010

Sum and chart in excel

as seen on Super User - Search for 'Super User'
I have data like the following: Both Hour and Count are columns in an excel file. Hour Count 17 79 18 122 19 123 20 142 21 150 22 78 23 15 13 33 14 33 15 40 16 33 17 56 18 46 19 35 20 67 21 65 22 45 23 36 What I want is to create a chart that shows over… >>> More
Offset the tickmarks of a secondary axis

as seen on Super User - Search for 'Super User'
I would like to offset the tickmarks of a secondary axis in excel WITHOUT changing the minimum. Here is a very complicated VBA class that apparently solves the issue but I would like a solution that doesn't require me to construct my entire chart in VBA. Here is an example of what I mean (I removed… >>> More
Find a non-case-sensitive text string within a range of cells

as seen on Super User - Search for 'Super User'
I've got a bit of a problem to solve in Excel, and I'm not quite sure how to go about doing it. I've done a few searches online, and haven't really found any formulas that seem to be useful. Here's the situation (simplified just a bit, for the purpose of this question): I have data in columns A-E… >>> More
Keyboard shortcut in excel for expanding the pivot table row?

as seen on Super User - Search for 'Super User'
I'm able to expand/collapse the row in the pivot table with mouse by: right clicking on cell in the first column of the row + selecting "Expand/Collapse"/"Expand" from context menu. or double clicking on the cell in the first column of the row Is there a keybord shortcut for same action? I'm using… >>> More
How can I split Excel data from one row into multiple rows

as seen on Super User - Search for 'Super User'
Good afternoon, Is there a way to split data from one row and store to separate rows? I have a large file that contains scheduling information and I'm trying to develop a list that comprises each combination of course, day, term and period per line. For example I have a file similiar to this: Crs:Sn… >>> More

Related posts about format

Custom rails route problem with 2.3.8 and Mongrel

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a controller called 'exposures' which I created automatically with the script/generate scaffold call. The scaffold pages work fine. I created a custom action called 'test' in the exposures controller. When I try to call the page (http://127.0.0.1:3000/exposures/test/1) I get a blank, white… >>> More
AuthnRequest Settings in OIF / SP

as seen on Oracle Blogs - Search for 'Oracle Blogs'
In this article, I will list the various OIF/SP settings that affect how an AuthnRequest message is created in OIF in a Federation SSO flow. The AuthnRequest message is used by an SP to start a Federation SSO operation and to indicate to the IdP how the operation should be executed: … >>> More
String Format for DateTime in C#

as seen on Samir ASP.NET with C# Technology - Search for 'Samir ASP.NET with C# Technology'
String Format for DateTime [C#] This example shows how to format DateTime using String.Format method. All formatting can be done also using DateTime.ToString method. Custom DateTime Formatting There are following custom format specifiers y (year), M (month), d (day), h (hour 12), H (hour 24)… >>> More
Video converter to convert any format to light-weight avi format(for mobile and portable multimedia

as seen on Super User - Search for 'Super User'
These answers don't satisfy MY needs. My mobile supports .3gp and .avi formats 3gp files are always smaller in size but with least quality (especially audio part) Avi (certainly) exhibits better quality but the video converter I am using (namely Xillisoft VidConverter) outputs avi file with very… >>> More
syslogd: Logfile format (not configuration format)

as seen on Server Fault - Search for 'Server Fault'
Hi, I'd like to parse logfiles. Is the logfile format of syslogd the same for all systems? On my system (Debian Lenny), it's: Mar 7 04:22:40 my-host-name ... (I'm not much interested in the ... part) Can I rely on this? And is there maybe some more-or-less official description? The manpage of… >>> More