Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
My date is coming up 0-Jan-00 when I type current date. Why?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
My date is coming up 0-Jan-00 when I type current date. Why?
You have a Lotus 123 setting toggled on.
Tools|Options|transition tab (in xl2003 menus) Uncheck all those options. Re-enter your date. ps. Please include your question in the body of the message--not just the subject. Clark wrote: -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
My date is coming up 0-Jan-00 when I type current date. Why?
"Dave Peterson" wrote:
You have a Lotus 123 setting toggled on. Tools|Options|transition tab (in xl2003 menus) I've never played with those options. Just curious.... Even when I set Transition Formula Evaluation and Transition Formula Entry, I cannot get 0-Jan-00 [sic] or any form of 0/0/1900. All I ever see is 1/0/1900. And I can get that without setting any Transition options, simply by entering zero into a cell formatted as Date. So how does one get effectively 0/0/1900 as a result of setting one or more Transition options? ----- original message ----- "Dave Peterson" wrote in message ... You have a Lotus 123 setting toggled on. Tools|Options|transition tab (in xl2003 menus) Uncheck all those options. Re-enter your date. ps. Please include your question in the body of the message--not just the subject. Clark wrote: -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
My date is coming up 0-Jan-00 when I type current date. Why?
If you turn on "transition formula entry", and enter the date as:
1/5/2010 Excel will pretend that it's Lotus 123, see the slashes as division symbols and automatically convert the entry to a formula (inserting an equal sign as the first character). You should see: =1/5/2010 in the formula bar when that cell is selected. And since 1 divided by 5 divided by 2010 is a very small number--much less than 1 and the cell is formatted as a date, you'll see January 0, 1900 (or its equivalent using your format). Joe User wrote: "Dave Peterson" wrote: You have a Lotus 123 setting toggled on. Tools|Options|transition tab (in xl2003 menus) I've never played with those options. Just curious.... Even when I set Transition Formula Evaluation and Transition Formula Entry, I cannot get 0-Jan-00 [sic] or any form of 0/0/1900. All I ever see is 1/0/1900. And I can get that without setting any Transition options, simply by entering zero into a cell formatted as Date. So how does one get effectively 0/0/1900 as a result of setting one or more Transition options? ----- original message ----- "Dave Peterson" wrote in message ... You have a Lotus 123 setting toggled on. Tools|Options|transition tab (in xl2003 menus) Uncheck all those options. Re-enter your date. ps. Please include your question in the body of the message--not just the subject. Clark wrote: -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
My date is coming up 0-Jan-00 when I type current date. Why?
"Dave Peterson" wrote:
And since 1 divided by 5 divided by 2010 is a very small number--much less than 1 and the cell is formatted as a date, you'll see January 0, 1900 (or its equivalent using your format). My mistake. I translated "0-Jan-00" to 0/0/1900 in my mind. Klunk! ----- original message ----- "Dave Peterson" wrote in message ... If you turn on "transition formula entry", and enter the date as: 1/5/2010 Excel will pretend that it's Lotus 123, see the slashes as division symbols and automatically convert the entry to a formula (inserting an equal sign as the first character). You should see: =1/5/2010 in the formula bar when that cell is selected. And since 1 divided by 5 divided by 2010 is a very small number--much less than 1 and the cell is formatted as a date, you'll see January 0, 1900 (or its equivalent using your format). Joe User wrote: "Dave Peterson" wrote: You have a Lotus 123 setting toggled on. Tools|Options|transition tab (in xl2003 menus) I've never played with those options. Just curious.... Even when I set Transition Formula Evaluation and Transition Formula Entry, I cannot get 0-Jan-00 [sic] or any form of 0/0/1900. All I ever see is 1/0/1900. And I can get that without setting any Transition options, simply by entering zero into a cell formatted as Date. So how does one get effectively 0/0/1900 as a result of setting one or more Transition options? ----- original message ----- "Dave Peterson" wrote in message ... You have a Lotus 123 setting toggled on. Tools|Options|transition tab (in xl2003 menus) Uncheck all those options. Re-enter your date. ps. Please include your question in the body of the message--not just the subject. Clark wrote: -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
My date is coming up 0-Jan-00 when I type current date. Why?
1/0/1900 formatted as d-mmm-yy displays 0-Jan-00
With all Transition Options enabled type 1/5/2009 in a cell. In formula bar see =1/5/2009 but cell displays 0-Jan-00 Gord Dibben MS Excel MVP On Tue, 5 Jan 2010 07:55:14 -0800, "Joe User" <joeu2004 wrote: "Dave Peterson" wrote: You have a Lotus 123 setting toggled on. Tools|Options|transition tab (in xl2003 menus) I've never played with those options. Just curious.... Even when I set Transition Formula Evaluation and Transition Formula Entry, I cannot get 0-Jan-00 [sic] or any form of 0/0/1900. All I ever see is 1/0/1900. And I can get that without setting any Transition options, simply by entering zero into a cell formatted as Date. So how does one get effectively 0/0/1900 as a result of setting one or more Transition options? ----- original message ----- "Dave Peterson" wrote in message ... You have a Lotus 123 setting toggled on. Tools|Options|transition tab (in xl2003 menus) Uncheck all those options. Re-enter your date. ps. Please include your question in the body of the message--not just the subject. Clark wrote: -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why is the date coming up as a | Excel Discussion (Misc queries) | |||
Figuring Vacation Hrs. Earned using Current Date minus Hire Date | Excel Worksheet Functions | |||
Find the date of the coming up Saturday given the current date. | Excel Worksheet Functions | |||
Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |