date problem or is it me?

[zekni]

Maturity dates.

My first maturity date is 6/7/2009 6 july 2009.(european)
When i change the month above 9 for ex 6/10/2009 i always get an error "number"
What did i do wrong?

Thanks you for answering

 

[Jarek Kujawa]

Excel 2003

Format->Cells->Numbers tab->select Date->select yr country in Regional
Settings

 

[zekni]

has been done on the installation.
On an other sheet these dates are accepted, but not here.
Belgium greets Poland

 

[zekni]

It was me.
Started everything again from zero.
Problem solved.
"zekni" <[email protected]> schreef in bericht Maturity dates.

My first maturity date is 6/7/2009 6 july 2009.(european)
When i change the month above 9 for ex 6/10/2009 i always get an error "number"
What did i do wrong?

Thanks you for answering