Format the cell as m/d/yyyy, you created the d-mmm format by just entering
7/4 so you need to reformat the cell to the date format you want. Always
use the full date when entering dates.


When it divides you have transition formula entry turned on, in Excel
previous to 2007 it is
under toolsoptionstransition

In 2007 it somewhere under the office button under excel options


--


Regards,


Peo Sjoblom


"manzoor" wrote in message
...
hi im new to excel 2007

i want to ask that when i type 7/4 in a cell excel thinks that the slash
is
division operator so it divides it ??

but in different cell it interpret it as date

ok another problem is that when I enter 7/4 in the different cell excel
interpret it as 4-Jul only but How do I display the year too ? even if i
type
7/4/2008 or 7/4/08 it still shows 4-JUL ?

Help please
thank you very much