What happens if you type in 38296 and then format that as date - It should be
11/06/2004

If it's not, then what happens to a cell formatted as number when you type in
that same number - Does the number change before your eyes as you hit enter?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Gail" <gailc550(at)yahoo(dot)ca wrote in message
...
I type in 11/5/2004 and teh result is 0.001097804. I format this to Number
with two decimal places and get 0.00. I format this to dd-mth-yy and get
00-jan-00

"Ken Wright" wrote:

If you entered Todays date in a cell, and got 00-Jan-00, what does it become
if
you format the cell as Number and add a couple of decimal places?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Gail" <gailc550(at)yahoo(dot)ca wrote in message
...
In SOME of my worksheets when i enter a date it always comes up as
00-Jan-00.
this does not occur in all sheets and no matter what i do re formatting the
cell i get the same thing. I have confirmed that Tools;Options is using
1900
and NOT 1904 system. I don't recall ever changing this. this problem
starting occuring after Y2K changeover. at one time i had a knowledge base
printout addressing this but have since lost it. I have searched Microsoft
KB again but could not find anything on this. It is strange that within
the
same workbook another sheet does not have this issue when i tested for it.
Some worksheets some times driving me crazy!--
Thank you for your help
Gail


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004