On my budget worksheets, I have a date column where I enter a date such as "3/14/15" but when I do that, Excel shows "3/14/1915". Why does it not recognize 2015 as the year if I enter just "15"? I have Excel 2010.
On my budget worksheets, I have a date column where I enter a date such as "3/14/15" but when I do that, Excel shows "3/14/1915". Why does it not recognize 2015 as the year if I enter just "15"? I have Excel 2010.
Hi, welcome to the forum
I am unable to replicate your problem Can you upload a sample WB where this is happening (although, I have a feeling it is a seting on your computer)?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ditto what FDibbins said
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
This is a quote from XL2003 help file, may need to check Excel version you use
For Microsoft Windows 2000 or later
If you are using Microsoft Windows 2000 or later, the Regional Options in Windows Control Panel controls how Excel interprets two-digit years
HTH
Thanks for the replies. I did some hunting around as M E Good suggested and found that the date for a 2-digit number just went to 2014 so I changed that so it showed "Between 1945 and 2030". All works well now. :-)
Hi PennyPA,
Reset your computer system clock to the correct year. I'd bet it is using the current year, as set in your computer system. Hope that is a good guess.
What does Excel do with =Today()? Does it say 2015?
Last edited by MarvinP; 03-07-2015 at 07:44 PM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks