[mso] Re: Standard Dates in Excel
- From: cjb4622@xxxxxxx
- To: mso@xxxxxxxxxxxxx
- Date: Mon, 28 Jun 2010 10:51:07 -0400
I am not sure how large/complex your file is, but you could try to copy and
paste the data into a new Excel spreadsheet... sometimes older files, or files
with large amounts of data, can become corrupt, and therefore they will start
to act up.
Hope this helps,
Chris
-----Original Message-----
From: Graham Jones <agjones@xxxxxxxxxxxxxx>
To: 'mso@xxxxxxxxxxxxx' <mso@xxxxxxxxxxxxx>
Sent: Mon, Jun 28, 2010 9:33 am
Subject: [mso] Re: Standard Dates in Excel
I remember coming across something like this a VEEEERY long time ago. Time
asses and the memory weakens, so I'm not sure but .....
Have you tried entering a NEW date, or replacing one already in the assigned
olumn, AFTER reformatting it?
Graham
-----Original Message-----
rom: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of
ohn Porter
ent: 28 June 2010 14:22
o: mso@xxxxxxxxxxxxx
ubject: [mso] Re: Standard Dates in Excel
TEXT(SourceCell,"mm/dd/yy")
n Tue, Apr 27, 2010 at 10:03 AM, Bill Mozer <billmozer@xxxxxxxxx> wrote:
> My date entries made in standard date format (04/28/2010) in Excel
2007 are being automatically converted to the Excel numeric format.
The real date appears in the entry window, but dates appear in numeric
format in the assigned column
I tried reformatting the cells to the standard date format to no avail.
Help, please.
Many thanks!
Bill
*************************************************************
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).
//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
*************************************************************
************************************************************
ou are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
icrosoftOffice@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
enu at the top. This will allow you to unsubscribe your email address or
hange your email settings to digest or vacation (no mail).
ttp://www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister group.
his group will not allow for posting of emails, but will allow you to join and
hare 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
essages, read these instructions that explain why and how to fix it:
ttp://personal-computer-tutor.com/abc3/v28/greg28.htm
************************************************************
###########################################################
lease consider the environment before printing this e-mail.
This e-mail message, including any attachments, is for the sole use of the
erson to whom it has been sent and may contain information that is confidential
r legally protected. If you are not the intended recipient or have received
his message in error, you are not authorized to copy, distribute, or otherwise
se this message or its attachments. Please notify the sender immediately by
eturn e-mail, and permanently delete this message and any attachments. Study
roup makes no warranty that this e-mail is error or virus free. Study Group
nternational Ltd, Registered in England, number 3108030, Registered office: 1
illinton Way, Brighton, East Sussex BN1 4LF. Study Group International Ltd is
he parent company of Bellerbys Educational Services and Embassy CES.
###########################################################
************************************************************
ou are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
icrosoftOffice@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
enu at the top. This will allow you to unsubscribe your email address or
hange your email settings to digest or vacation (no mail).
ttp://www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister group.
his group will not allow for posting of emails, but will allow you to join and
hare 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
essages, read these instructions that explain why and how to fix it:
ttp://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).
//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:
