Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 60
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,651
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 60
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.misc
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



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 618
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Identifying unique dates within a range of cells containing dates cdavidson Excel Discussion (Misc queries) 0 October 12th 06 08:19 PM
Entering Dates for a Prior Year Stranded Excel Discussion (Misc queries) 0 September 8th 06 06:34 PM
need to convert list of dates to count no. of dates by week neowok Excel Worksheet Functions 13 January 30th 06 04:54 PM
Trouble with dates...... DavidMunday Excel Worksheet Functions 0 June 27th 05 08:50 PM
Trouble with Dates between 2 seperate worksheets Julie Excel Discussion (Misc queries) 3 March 4th 05 08:57 PM


All times are GMT +1. The time now is 03:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"