[mso] Re: Date format in Excel

i'm not sure about the 01st... 1st yes...  got to format - cells - select date 
and you'll see a list of the various formats...   
if your looking to do it programatically you would use the format function, 
help will give you the syntax as well as the formats.... 

"Rajesh  V - Program Leader(BC) - SIS" <rajesh.v@xxxxxxxxxxxxxxxxxxx> wrote: Hi 
All, 
I need the date format in excel to be as 01st Oct 2007, 02nd Oct 2007
etc.  Is it possible to set any custom value .  Please help.

Thanks and regards

Rajesh

 

"Rajesh  V - Program Leader(BC) - SIS" 

___________________________________________________________________________

Visit us at www.sundaraminfotech.in
___________________________________________________________________________

This E-mail may contain privileged information and is intended solely for the 
addressee, and any disclosure of this information is strictly prohibited, and 
may be unlawful.  If you have received this mail by mistake, please inform us 
immediately and delete this mail.  Any information expressed in this mail does 
not necessarily reflect the views of SUNDARAM INFOTECH SOLUTIONS.  As per 
SUNDARAM INFOTECH SOLUTIONS's policy, unencrypted mail via Internet is not 
considered secure.
___________________________________________________________________________

*************************************************************
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, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************



*************************************************************
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, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: