[mso] Re: Standard Dates in Excel
- From: "David Smart" <smartware@xxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Wed, 28 Apr 2010 00:40:50 +1000
Dates are stored as numbers in Excel. The conversion of entered dates to
numbers is correct and automatic.
So, if you format the cell for example as "General" you will see a number
like 40296, which is 28/4/2010.
> The real date appears in the entry window, but dates
> appear in numeric format in the assigned column
I'm not sure I'm with you on this. What do you mean by "assigned column"?
The entry bar should show the date in approximately the same format as the
cell itself is displaying. In particular, if the cell is displaying just a
number like 40295, then the entry bar should show that number too.
Do you mean that you have a formula that takes the value of the cell with
the date in it and that this formula is displaying the number? If so, then
you need to format that cell to display a date too.
> I tried reformatting the cells to the standard date format to no avail.
Not sure what you're actually doing here, but it should definitely work.
Try the following (assuming you're using Excel 2003) in a new worksheet
Type 40296 into A1 and hit Enter.
Re-select A1 if the selection moves after you hit Enter.
On the menu, select Format / Cells - the General format should be
highlighted.
Click on Date category and click on OK.
A1 should now be showing 28/04/2010 or 04/28/2010 or whatever is your
default date format.
The entry bar should also be showing the contents in date format.
The entry bar will always show you a full numeric date, I think, regardless
of the specific date format you're displaying the cell in.
Remember that dates and times are just numbers in Excel. You need to format
the cells to display them as dates/times as appropriate.
Regards, Dave S
----- Original Message -----
From: "Bill Mozer" <billmozer@xxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Wednesday, April 28, 2010 12:03 AM
Subject: [mso] Standard Dates in Excel
> 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
> *************************************************************
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.437 / Virus Database: 271.1.1/2837 - Release Date: 04/26/10
18:27:00
*************************************************************
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:
