Prev: Past Questions and Answers
Next: leading zero
From: Gord Dibben on 5 Jan 2010 12:59
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" <petersod(a)verizonXSPAM.net> 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" <petersod(a)verizonXSPAM.net> wrote in message
>news:4B434D4E.8BB9519D(a)verizonXSPAM.net...
>> 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

First  |  Prev  | 
Pages: 1 2
Prev: Past Questions and Answers
Next: leading zero