trouble entering dates
 

can someone help me with this:

when i enter a date, let's say

09/01/2006

it is display as 00-Jan-00, and the cell contains =09/01/2006

how can i enter it as the date that i want, which is 09/01/2006

thanks a lot for your help

trouble entering dates
 

Tools|Options|transition tab
Uncheck all those old lotus 123 settings.

andresg1975 wrote:

can someone help me with this:

when i enter a date, let's say

09/01/2006

it is display as 00-Jan-00, and the cell contains =09/01/2006

how can i enter it as the date that i want, which is 09/01/2006

thanks a lot for your help

--

Dave Peterson

trouble entering dates
 

On Mon, 6 Nov 2006 08:50:02 -0800, andresg1975
wrote:

can someone help me with this:

when i enter a date, let's say

09/01/2006

it is display as 00-Jan-00, and the cell contains =09/01/2006

how can i enter it as the date that i want, which is 09/01/2006

thanks a lot for your help


Tools/Options/Transition and DEselect "Transition Formula Entry"


--ron

trouble entering dates
 

thank you so much

"Dave Peterson" wrote:

Tools|Options|transition tab
Uncheck all those old lotus 123 settings.

andresg1975 wrote:

can someone help me with this:

when i enter a date, let's say

09/01/2006

it is display as 00-Jan-00, and the cell contains =09/01/2006

how can i enter it as the date that i want, which is 09/01/2006

thanks a lot for your help

--

Dave Peterson

trouble entering dates
 

thank you

"Ron Rosenfeld" wrote:

On Mon, 6 Nov 2006 08:50:02 -0800, andresg1975
wrote:

can someone help me with this:

when i enter a date, let's say

09/01/2006

it is display as 00-Jan-00, and the cell contains =09/01/2006

how can i enter it as the date that i want, which is 09/01/2006

thanks a lot for your help


Tools/Options/Transition and DEselect "Transition Formula Entry"


--ron

trouble entering dates
 

Take out the equals sign.

In that formula you have asked it to divide 9 by 1 and then divide by 2006.
That evaluates to about 0.0045, or a time of about 00:06:28 on the first day
of Excel's date system.
--
David Biddulph

"andresg1975" wrote in message
...
can someone help me with this:

when i enter a date, let's say

09/01/2006

it is display as 00-Jan-00, and the cell contains =09/01/2006

how can i enter it as the date that i want, which is 09/01/2006

thanks a lot for your help