Jan,
Ok, if I understand the problem right, you have an Excel document and you open it in Open Office. When you open it in Open Office Calc, all the dates are changed? Highlight all the cells that are displayed wrong (assuming they are all dates), Select format, and then Cells. On the first tab you can select what type of number is being put in. You will need to select the date format, and then however you prefer the date. Your example didn't help me much because I don't speak that language. Maybe someone else understood the example better. Good Luck.
Shane
jan wrote:
hello my englisch is not so good i am sorry.
i have a program birdday excel
if i used this in open office then things are change manday is sutterday this things with the same eh ... i show you
=DEEL(TEKST(WEEKDAG(DAG(A2)&"-"&MAAND(C$1)&"-"&$A$1);"ddd");1;2)
=DEEL(TEKST(WEEKDAG(DAG(A2)&"-"&MAAND(C$1)&"-"&$A$1);"ddd");1;2)
=DEEL(TEKST(WEEKDAG(DAG(M4)&"-"&MAAND(O$1)&"-"&$A$1);"ddd");1;2)
=DEEL(TEKST(WEEKDAG(DAG(M4)&"-"&MAAND(O$1)&"-"&$A$1);"ddd");1;2)
so maby you no it thanks jan lespau
------------------------------------------------------------------------
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
