I believe this *may* have something to do with the lists that are set up. When you autofill in Excel for months and so on, the items are taken from a set up list of days, months etc. Those lists may have been entered in lower case. I'm not sure where to look for them so maybe someone can jump in. Alternatively ... perhaps it's an autocorrect item?? Lisa > Hi Robert, > I'm using Excel 2000 - For me also, this format will not > capitalize the weekday. > I don't think this is due to the regional settings. My > weekday comes out correctly in Portuguese, but not > capitalized. In fact, not even the first letter of the > weekday is capitalized. And the format, though entered as > yyyy-mm-dd DDD, goes back to yyyy-mm-dd ddd. May have > something to do with the Excel version. > > Wilson > > At 10:15 1/3/2006,Robert Carneal wrote: > >I believe you when you say it works for you. But, it > isn't for me. Could it > >be related to my preferred date format I set in the > Regional and Language > >Options, I wonder? > > > >I still get this format: > >2004-02-28 Tue, and not 2004-02-28 TUE. I am trying to get > the latter. > > > >Thank you. > > > >Robert -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.1.1/271 - Release Date: 28/02/2006 ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************