ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   date problem or is it me? (https://www.excelbanter.com/excel-worksheet-functions/194523-date-problem-me.html)

zekni

date problem or is it me?
 
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[_2_]

date problem or is it me?
 
Excel 2003

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

zekni

date problem or is it me?
 
has been done on the installation.
On an other sheet these dates are accepted, but not here.
Belgium greets Poland

"Jarek Kujawa" schreef in bericht
...
Excel 2003

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




zekni

date problem or is it me?
 
It was me.
Started everything again from zero.
Problem solved.
"zekni" 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








All times are GMT +1. The time now is 03:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com