Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date changes to 0-Jan-00 when I leave cell
The cell format is set to Number, Date, 14-Mar-01. I enter the date, and
when I press Enter, the date converts to 0-Jan-00. Any thoughts? Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date changes to 0-Jan-00 when I leave cell
What date did you enter? What does the formula bar show? What value do you
see if you temporarily reformat the cell to General? You would, of course, see the 0th of January 1900 if your cell contained a formula such as =12/5/2009, as 12 divided 5 then by 2009 is a number less than 1, and Excel dates count in whole days from 0th Jan 1900. -- David Biddulph "hvannest" wrote in message ... The cell format is set to Number, Date, 14-Mar-01. I enter the date, and when I press Enter, the date converts to 0-Jan-00. Any thoughts? Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date changes to 0-Jan-00 when I leave cell
A corollary of the second part of my reply below is that if you have Tools/
Options/ Transition set to enable "transition formula entry", then entering 12/5/2009 in the cell would change to =12/5/2009, so I would recommend that you check, and if necessary disable, that transition option. -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... What date did you enter? What does the formula bar show? What value do you see if you temporarily reformat the cell to General? You would, of course, see the 0th of January 1900 if your cell contained a formula such as =12/5/2009, as 12 divided 5 then by 2009 is a number less than 1, and Excel dates count in whole days from 0th Jan 1900. -- David Biddulph "hvannest" wrote in message ... The cell format is set to Number, Date, 14-Mar-01. I enter the date, and when I press Enter, the date converts to 0-Jan-00. Any thoughts? Thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date changes to 0-Jan-00 when I leave cell
I entered the date as 5/12/09. As I'm entering it, the formula bar shows
5/12/09. Once I press Enter, when I go back into the cell, the formula bar shows =5/12/09 which I understand is what you're explaining below. If I format the cell to General then I get 0.046296296, which also makes sense, given the "=" in the formula bar. Why would it be changing it from the date to a formula? "David Biddulph" wrote: What date did you enter? What does the formula bar show? What value do you see if you temporarily reformat the cell to General? You would, of course, see the 0th of January 1900 if your cell contained a formula such as =12/5/2009, as 12 divided 5 then by 2009 is a number less than 1, and Excel dates count in whole days from 0th Jan 1900. -- David Biddulph "hvannest" wrote in message ... The cell format is set to Number, Date, 14-Mar-01. I enter the date, and when I press Enter, the date converts to 0-Jan-00. Any thoughts? Thank you. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date changes to 0-Jan-00 when I leave cell
Success - thank you!
"David Biddulph" wrote: A corollary of the second part of my reply below is that if you have Tools/ Options/ Transition set to enable "transition formula entry", then entering 12/5/2009 in the cell would change to =12/5/2009, so I would recommend that you check, and if necessary disable, that transition option. -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... What date did you enter? What does the formula bar show? What value do you see if you temporarily reformat the cell to General? You would, of course, see the 0th of January 1900 if your cell contained a formula such as =12/5/2009, as 12 divided 5 then by 2009 is a number less than 1, and Excel dates count in whole days from 0th Jan 1900. -- David Biddulph "hvannest" wrote in message ... The cell format is set to Number, Date, 14-Mar-01. I enter the date, and when I press Enter, the date converts to 0-Jan-00. Any thoughts? Thank you. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date changes to 0-Jan-00 when I leave cell
Glad to be able to help.
-- David Biddulph "hvannest" wrote in message ... Success - thank you! "David Biddulph" wrote: A corollary of the second part of my reply below is that if you have Tools/ Options/ Transition set to enable "transition formula entry", then entering 12/5/2009 in the cell would change to =12/5/2009, so I would recommend that you check, and if necessary disable, that transition option. -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... What date did you enter? What does the formula bar show? What value do you see if you temporarily reformat the cell to General? You would, of course, see the 0th of January 1900 if your cell contained a formula such as =12/5/2009, as 12 divided 5 then by 2009 is a number less than 1, and Excel dates count in whole days from 0th Jan 1900. -- David Biddulph "hvannest" wrote in message ... The cell format is set to Number, Date, 14-Mar-01. I enter the date, and when I press Enter, the date converts to 0-Jan-00. Any thoughts? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I leave linked cells that do not contain a date | Excel Discussion (Misc queries) | |||
Date Formula Problem - Leave date blank if Null | Excel Worksheet Functions | |||
if=0 then n/a if<0 leave the value in the cell | Excel Worksheet Functions | |||
How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
leave a cell blank | Excel Worksheet Functions |