[mso] Re: Excel 2000- Capitlize day abbreviations?
- From: "Pearce, Norman" <Norman.Pearce@xxxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Wed, 1 Mar 2006 13:33:08 -0000
AS long as you do not necessarily need to retain the result date in date
format you could convert to text using the following:
= UPPER(TEXT(A1, "yyyy-mm-dd ddd"))
where A1 contains the original date.
Hope this helps.
Regards
Norman Pearce
IM&T Learning Manager
The Training Centre
Ealing Hospital NHS Trust
UK
Developing the foundations for your success
-----Original Message-----
From: Robert Carneal [mailto:carnealre@xxxxxxxxxxxx]
Sent: 01 March 2006 13:16
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel 2000- Capitlize day abbreviations?
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
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On Behalf Of
Pearce, Norman
Sent: 2006-03-01 06:03
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Excel 2000- Capitlize day abbreviations?
In Excel the Format Cells - Number - Custom format yyyy-mm-dd DDD works
perfectly for me.
Regards
Norman Pearce
IM&T Learning Manager
The Training Centre
Ealing Hospital NHS Trust
UK
Developing the foundations for your success
-----Original Message-----
From: Andrew [mailto:ak_lists@xxxxxxxxxxxx]
Sent: 28 February 2006 08:06
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel 2000- Capitlize day abbreviations?
Robert,
In Custom format, the string yyyy-mm-dd ddd works for me. I am using Outlook
2003.
You can also use the following: =UPPER(TEXT([date],"yyyy-mm-dd ddd")) which
is best used where [date] is the reference to the cell where the date is.
Andrew
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx
> [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Robert Carneal
> Sent: 28 February 2006 00:32
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Excel 2000- Capitlize day abbreviations?
>
> In Excel 2000, can I format dates so they appear as:
>
> 2006-02-27 TUE ???
>
> It wants to appear as 2006-02-27 Tue.
>
> I tried in customize: YYYY-MM-DD ddd, but no go.
>
> Thank you.
>
> Robert
*************************************************************
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
*************************************************************
*************************************************************
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
*************************************************************
Other related posts:
