yet another date format problem

[Paula]

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

 

[Bob Greenblatt]

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

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.

 

[Phillip Jones]

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.

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.

--
------------------------------------------------------------------------
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 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<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>

 

[Paula]

i did both things, it worked. thanks a lot.