| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
| Entering Dates for a Prior Year | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Trouble with dates...... | Excel Worksheet Functions | |||
| Trouble with Dates between 2 seperate worksheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
