View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
andresg1975 andresg1975 is offline
external usenet poster
 
Posts: 60
Default 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