[mso] Re: Date format in Excel

I think the problem you are seeing here is that the original cell has not been 
entered as a DATE as you have indicated.  The original cells have been entered 
as TEXT and when you grab the fill handle and extend the column down you get a 
TEXT progression of similar data.
   
  Note that there is no rollover to the next month once you get to the end of 
October:
   
  01st Oct 2007
  02nd oct 2007
  03rd oct 2007
  .
  .
  .
  31st Oct 2007
  32nd Oct 2007
  33rd Oct 2007
  .
  .
  .
   
  I'm not sure you can manipulate this TEXT field directly using standard Excel 
to get what you want, but you may be able to create a simple lookup table or 
something similar to get the output to display as you need.
   
  Create a lookup sheet once and then add it to your various workbooks as 
needed with the associated code.  There are several ways you could get your 
results to display: hide columns, copy to a new sheet, copy paste special 
values in the original cells --- it just depends on what you are most 
comfortable doing and how you need to use the resulting cells.  This lookup 
data column could not be used for calculations, you would need the original 
data to be entered as a DATE in order to do calcualtions on those cells.
   
  
"Rajesh V - Program Leader(BC) - SIS" <rajesh.v@xxxxxxxxxxxxxxxxxxx> wrote:
  Thanks for your reply Mr David

See when we enter the date in excel as 01st Oct 2007 and use the fill
handle and drag it down, excel automatically recognises the series and
fills the same as 02nd oct 2007, 03rd oct 2007 etc. Hence I put forth a
question that since excel is able to internally recognise the formats,
is there by any chance we change the format as above.

When I enter the date as 01-oct-2007 and set an format to that, it
should change to 01st oct 2007.

Hope I am clear now.


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of David Smart
Sent: Tuesday, October 30, 2007 6:04 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Date format in Excel

Sorry, not with you.

What specific format does Excel recognise?

What is the issue you have with changing the format?

Regards, Dave S

----- Original Message -----=20
From: "Rajesh V - Program Leader(BC) - SIS"

To: 
Sent: Tuesday, October 30, 2007 2:49 PM
Subject: [mso] Re: Date format in Excel


> Thanks for this advise. But excel recognises the format and when we
use
> the fill handle, it automatically generates the sequence in the way
> which I require. The only issue is when I want to change the format.
> Please advise
>
>
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
> Behalf Of David Smart
> Sent: Tuesday, October 30, 2007 3:17 AM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Re: Date format in Excel
>
> You can have the leading zero on the day without trouble. I think
that
> this=3D20
> is one of the standard date formats.
>
> I don't believe there is any built-in Excel facility that will give
you=3D20
> "st", "nd", etc.
>
> Regards, Dave S
>
> ----- Original Message -----=3D20
> From: "Rajesh V - Program Leader(BC) - SIS"
> 
> To: 
> Sent: Tuesday, October 30, 2007 12:26 AM
> Subject: [mso] Date format in Excel
>
>
>> 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=3D20
>> the addressee, and any disclosure of this information is =
strictly=3D20
>> prohibited, and may be unlawful. If you have received this mail
by=3D20
>> mistake, please inform us immediately and delete this mail. Any=3D20
>> information expressed in this mail does not necessarily reflect the
> views=3D20
>> of SUNDARAM INFOTECH SOLUTIONS. As per SUNDARAM INFOTECH
SOLUTIONS's=3D20
>> policy, unencrypted mail via Internet is not considered secure.
>>
>
________________________________________________________________________
> ___
>>
>> *************************************************************
>> You are receiving this mail because you subscribed to
> mso@xxxxxxxxxxxxx or=3D20
>> 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=3D20
>> 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=3D20
>> group. This group will not allow for posting of emails, but will
> allow=3D20
>> you to join and share problem files, templates, etc.:=3D20
>> 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=3D20
>> it:
>> http://personal-computer-tutor.com/abc3/v28/greg28.htm
>> *************************************************************=3D20
>
> *************************************************************
> 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
> *************************************************************
> "Rajesh V - Program Leader(BC) - SIS" 
>
>
________________________________________________________________________
_=3D
> __
>
> Visit us at www.sundaraminfotech.in
>
________________________________________________________________________
_=3D
> __
>
> This E-mail may contain privileged information and is intended solely
=3D
> for the addressee, and any disclosure of this information is strictly
=3D
> prohibited, and may be unlawful. If you have received this mail by =
=3D
> mistake, please inform us immediately and delete this mail. Any =3D
> information expressed in this mail does not necessarily reflect the =
=3D
> views of SUNDARAM INFOTECH SOLUTIONS. As per SUNDARAM INFOTECH =3D
> SOLUTIONS's policy, unencrypted mail via Internet is not considered =
=3D
> secure.
>
________________________________________________________________________
_=3D
> __
> *************************************************************
> You are receiving this mail because you subscribed to
mso@xxxxxxxxxxxxx or=20
> 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=20
> 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=20
> group. This group will not allow for posting of emails, but will
allow=20
> you to join and share problem files, templates, etc.:=20
> 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=20
> it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> *************************************************************=20

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


 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

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