 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / January 2008yet another date format problem
hello, I'm using Excel 2004 in Mac OS X Tiger. I use dates in dd/mm/yy format, and that's how it is set in my international preferences panel and how i formated the Excel column. but then i type, say, 4/11/07 (to enter the date 4th nov 07) and excel converts it to 11/04/07. it's like if excel understands that i'm entering the date in mm/dd/yy format even though the system preferences is dd/mm/yy. why the heck excel is doing that? thanks a lot paula On 1/28/08 3:47 AM, in article 1d303bd2-c00c-48f6-aaf9-fd5b272d1da6@u10g2000prn.googlegroups.com, "Paula" <paulartcoelho@gmail.com> wrote: > hello, > [quoted text clipped - 11 lines] > thanks a lot > paula Excel does indeed understand what you are typing as a date and formats it. Have you restarted Excel since you updated the system preferences? Excel only reads thins information when it opens.  SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom Also highlight the desired cell or cells you want a specific Date format. example January 28, 2008. Go to Format menu and choose cells Then click on Date. from a List choose January 28, 2008 as desired format. or if is not listed select Custom scroll list and find closest version and in a box you will see that format something similar mm dd, yyyy Change to mmmm dd, yyyy You may be asked to save. if so do. will be available for use another time. > On 1/28/08 3:47 AM, in article > 1d303bd2-c00c-48f6-aaf9-fd5b272d1da6@u10g2000prn.googlegroups.com, "Paula" [quoted text clipped - 18 lines] > Have you restarted Excel since you updated the system preferences? Excel > only reads thins information when it opens. Signature------------------------------------------------------------------------ Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling 616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868 Martinsville Va 24112 |pjones@kimbanet.com, ICQ11269732, AIM pjonescet ------------------------------------------------------------------------ If it's "fixed", don't "break it"! mailto:pjones@kimbanet.com <http://www.kimbanet.com/~pjones/default.htm> <http://www.kimbanet.com/~pjones/90th_Birthday/index.htm> <http://www.kimbanet.com/~pjones/Fulcher/default.html> <http://www.kimbanet.com/~pjones/Harris/default.htm> <http://www.kimbanet.com/~pjones/Jones/default.htm> <http://www.vpea.org> i did both things, it worked. thanks a lot. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.