I am entering a list of format dates for Feb 2012. When I enter the date 2/28/2012 I can format it as 28 Feb with no problem. If I enter 2/29/2012 the entry stays the same. See attached file.
Jim O
I am entering a list of format dates for Feb 2012. When I enter the date 2/28/2012 I can format it as 28 Feb with no problem. If I enter 2/29/2012 the entry stays the same. See attached file.
Jim O
Last edited by JO505; 11-28-2011 at 04:38 PM.
The year you entered is 2029, not 2012.
Entia non sunt multiplicanda sine necessitate
You entered it as 2/29/2029
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
Oops!!Damn Mondays!
Thank you both.
Jim O
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks