To be clear, I want to be able to enter 7/29 into a cell and receive 7/29/2013 NOT 29-Jul.
(It is time consuming to go through the process of formatting the cells via the 'format cells...' option)
I have gone through the region and language settings in the control panel, but this did not remedy the problem.
I have found numerous threads about this issue but none have a solution.
Please, someone tell me they have figured this out.
I use MS Excel 2010 without changing the for i try to enter 7/29 and the result is 7/29/2013. Maybe your excel is already formatted to came a date of 29-Jul. try to open new excel and try to enter 7/29.
I use MS Excel 2007 as well, but any and all sheets that I open default to the format 29-Jul when 9/29 is typed in a cell.
Someone please help me figure this out.
I use that and excel for mac, I just tried it and it came out as 29-Jul as you noted. Then I just went to format cell and selected Date then 3/14/2001 (the example in excel) and it came out as you wanted.
You can highlight the column and it should format all as that or use the format painter to do same on a whole column.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Yes, format cell works but when entering hundreds of data points with corresponding dates that need to be formatted MM/DD/YYYY having the DEFAULT format be MM/DD/YYYY would be preferred. Reformatting every single cell is time consuming.
You can click on the column and use the format cells to do the whole column. You can also double click on the format painter and hold down control + shift and the down arrow and it will format the whole column (at least until it hits a break in the data) at one time for you.
Last edited by Sam Capricci; 08-01-2013 at 10:12 AM.
Yes but I am looking to change the default format.
Hmmm, sorry to be wasting your time then. I'm looking into excel options to see if there is a default setting but the only one I'm seeing applying to dates is under advanced and it relates to the 1900 vs 1904 date system.
Excel has no way of knowing what the year is of the date is that you are entering.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
It seems Excel knows the year is the current year (if you enter 7/29 into a cell, Excel expresses it as 29-Jul, then you manually format the cell to MM/DD/YYYY and Excel expresses the year 2013).
If Excel knows the year when I manually format the cell, wouldn't it know the year if that same format were the default format?
well I noticed it did the same thing in my 2011 iMac excel version at home so I just reformatted it. At work my version is office 2007 (same as yours I think) and if I just type in 7/29 it auto populates it as 7/29/2013 so it must be something coded in under options?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks