|
| View previous topic :: View next topic |
| Author |
Message |
Heiner Intzen
Guest
|
 Posted: Sat Nov 17, 2007 4:53 pm Post subject: Datum Format |
 |
|
Hallo NG,
Mein englisch ist leider nicht so gut aber ich versuche mich trotzdem
einmal.
Kann man in Works-Tabellenkalkulation 2000, das Datum so ändern:
von 17.11.2007 nach So. 17.11.2007 oder nur in einer Zelle A2 als "So"
Zelle B2 als "17.11.2007"
Falls ja, wie geht dies?
Gruß - Heiner
NS
Wer Schreibfehler findet, darf sie ohne Nachfrage behalten. |
|
| Back to top |
|
 |
Google
Sponsor
|
| Posted: Sat Nov 17, 2007 4:53 pm Post subject: Advertisement |
|
|
|
|
| Back to top |
|
|
Ken
Guest
|
| Posted: Sat Nov 17, 2007 7:46 pm Post subject: Re: Datum Format |
|
|
Translated.......
Hello NG,
However, unfortunately, mine is not in English so well I try, nevertheless
once.
If one can in Works-table calculation in 2000 change the date so:
from 17.11.2007 after In such a way. 17.11.2007 or only in a cell A2 as "In
such a way"
Cell B2 as "17.11.2007"
If yes, how this goes?
Greeting - Heiner
NS
Who finds write error, it may keep without inquiry.
"Heiner Intzen" <Heinersein@t-online.de> wrote in message
news:ucM2spTKIHA.5208@TK2MSFTNGP04.phx.gbl...
| Hallo NG,
|
| Mein englisch ist leider nicht so gut aber ich versuche mich trotzdem
| einmal.
|
| Kann man in Works-Tabellenkalkulation 2000, das Datum so ändern:
|
| von 17.11.2007 nach So. 17.11.2007 oder nur in einer Zelle A2 als "So"
| Zelle B2 als "17.11.2007"
|
| Falls ja, wie geht dies?
|
| Gruß - Heiner
|
|
| NS
| Wer Schreibfehler findet, darf sie ohne Nachfrage behalten.
| |
|
| Back to top |
|
|
Erik Jan
Guest
|
| Posted: Sat Nov 17, 2007 8:05 pm Post subject: Re: Datum Format |
|
|
Heiner Intzen had de volgende lumineuze gedachte op 17-11-07 17:53:
| Quote: | Hallo NG,
Mein englisch ist leider nicht so gut aber ich versuche mich trotzdem
einmal.
Kann man in Works-Tabellenkalkulation 2000, das Datum so �ndern:
von 17.11.2007 nach So. 17.11.2007 oder nur in einer Zelle A2 als "So"
Zelle B2 als "17.11.2007"
Falls ja, wie geht dies?
Gru� - Heiner
NS
Wer Schreibfehler findet, darf sie ohne Nachfrage behalten.
|
I believe the question is this:
Is it possible in Works Spreadsheet to change the date format from
"17.11.2007" to "Sat. 17.11.2007" (I interpret the German "So." to mean
the day of the week. November seventeenth however -- today -- is
Saturday, not Sunday, "Sontag".)
Erik Jan |
|
| Back to top |
|
|
Ken
Guest
|
| Posted: Sat Nov 17, 2007 9:54 pm Post subject: Re: Datum Format |
|
|
Hi Eric,
If day of week is desired the formula in B2 is....
=CHOOSE(MOD(A2,7),"Saturday","Sunday","Monday","Tuesday","Wednesday","Thursd
ay","Friday")
Ken
"Erik Jan" <anonymous@discussions.microsoft.com> wrote in message
news:e4MGDVVKIHA.1168@TK2MSFTNGP02.phx.gbl...
Heiner Intzen had de volgende lumineuze gedachte op 17-11-07 17:53:
| Quote: | Hallo NG,
Mein englisch ist leider nicht so gut aber ich versuche mich trotzdem
einmal.
Kann man in Works-Tabellenkalkulation 2000, das Datum so �ndern:
von 17.11.2007 nach So. 17.11.2007 oder nur in einer Zelle A2 als "So"
Zelle B2 als "17.11.2007"
Falls ja, wie geht dies?
Gru� - Heiner
NS
Wer Schreibfehler findet, darf sie ohne Nachfrage behalten.
|
I believe the question is this:
Is it possible in Works Spreadsheet to change the date format from
"17.11.2007" to "Sat. 17.11.2007" (I interpret the German "So." to mean
the day of the week. November seventeenth however -- today -- is
Saturday, not Sunday, "Sontag".)
Erik Jan |
|
| Back to top |
|
|
Heiner Intzen
Guest
|
| Posted: Sun Nov 18, 2007 1:24 pm Post subject: Re: Datum Format |
|
|
Hallo Ken,
Erst einmal Danke für deine Hilfe und Übersetzung. Könntest du mir bitte
sagen, mit welchelm Programm hast du dies übersetzt?
Gruß und frohes Schaffen.
Heiner
"Ken" <PleaseReply@NewsGroup.Thanks> schrieb im Newsbeitrag
news:OGH67JVKIHA.4584@TK2MSFTNGP03.phx.gbl
| Quote: | Translated.......
Hello NG,
However, unfortunately, mine is not in English so well I try,
nevertheless once.
If one can in Works-table calculation in 2000 change the date so:
from 17.11.2007 after In such a way. 17.11.2007 or only in a cell A2
as "In such a way"
Cell B2 as "17.11.2007"
If yes, how this goes?
Greeting - Heiner
NS
Who finds write error, it may keep without inquiry.
"Heiner Intzen" <Heinersein@t-online.de> wrote in message
news:ucM2spTKIHA.5208@TK2MSFTNGP04.phx.gbl...
Hallo NG,
Mein englisch ist leider nicht so gut aber ich versuche mich trotzdem
einmal.
Kann man in Works-Tabellenkalkulation 2000, das Datum so ändern:
von 17.11.2007 nach So. 17.11.2007 oder nur in einer Zelle A2 als
"So" Zelle B2 als "17.11.2007"
Falls ja, wie geht dies?
Gruß - Heiner
NS
Wer Schreibfehler findet, darf sie ohne Nachfrage behalten. |
|
|
| Back to top |
|
|
Heiner Intzen
Guest
|
| Posted: Sun Nov 18, 2007 1:30 pm Post subject: Re: Datum Format |
|
|
Hallo Erik Jan,
Yes thats rigth, but how can i do so?
Greatings from Hamburg Germany
Heiner
"Erik Jan" <anonymous@discussions.microsoft.com> schrieb im Newsbeitrag
news:e4MGDVVKIHA.1168@TK2MSFTNGP02.phx.gbl
| Quote: | Heiner Intzen had de volgende lumineuze gedachte op 17-11-07 17:53:
Hallo NG,
Mein englisch ist leider nicht so gut aber ich versuche mich trotzdem
einmal.
Kann man in Works-Tabellenkalkulation 2000, das Datum so �ndern:
von 17.11.2007 nach So. 17.11.2007 oder nur in einer Zelle A2 als
"So" Zelle B2 als "17.11.2007"
Falls ja, wie geht dies?
Gru� - Heiner
NS
Wer Schreibfehler findet, darf sie ohne Nachfrage behalten.
I believe the question is this:
Is it possible in Works Spreadsheet to change the date format from
"17.11.2007" to "Sat. 17.11.2007" (I interpret the German "So." to
mean the day of the week. November seventeenth however -- today -- is
Saturday, not Sunday, "Sontag".)
Erik Jan |
|
|
| Back to top |
|
|
Ken
Guest
|
| Posted: Sun Nov 18, 2007 2:44 pm Post subject: Re: Datum Format |
|
|
Translation from this web site.
Übersetzung von dieser Web site.
http://babelfish.altavista.com/tr
Ken
"Heiner Intzen" <Heinersein@t-online.de> wrote in message
news:ee5XvceKIHA.4808@TK2MSFTNGP05.phx.gbl...
Hello Ken, Only once thanks for your assistance and translation. Could you
say to me please, with welchelm program you this translated? Greeting and
glad work. Heiner
| Hallo Ken,
|
| Erst einmal Danke für deine Hilfe und Übersetzung. Könntest du mir bitte
| sagen, mit welchelm Programm hast du dies übersetzt?
|
| Gruß und frohes Schaffen.
| Heiner
|
| "Ken" <PleaseReply@NewsGroup.Thanks> schrieb im Newsbeitrag
| news:OGH67JVKIHA.4584@TK2MSFTNGP03.phx.gbl
| > Translated.......
| >
| > Hello NG,
| >
| > However, unfortunately, mine is not in English so well I try,
| > nevertheless once.
| >
| > If one can in Works-table calculation in 2000 change the date so:
| >
| > from 17.11.2007 after In such a way. 17.11.2007 or only in a cell A2
| > as "In such a way"
| > Cell B2 as "17.11.2007"
| >
| > If yes, how this goes?
| >
| > Greeting - Heiner
| >
| >
| > NS
| > Who finds write error, it may keep without inquiry.
| >
| > "Heiner Intzen" <Heinersein@t-online.de> wrote in message
| > news:ucM2spTKIHA.5208@TK2MSFTNGP04.phx.gbl...
| >> Hallo NG,
| >>
| >> Mein englisch ist leider nicht so gut aber ich versuche mich trotzdem
| >> einmal.
| >>
| >> Kann man in Works-Tabellenkalkulation 2000, das Datum so ändern:
| >>
| >> von 17.11.2007 nach So. 17.11.2007 oder nur in einer Zelle A2 als
| >> "So" Zelle B2 als "17.11.2007"
| >>
| >> Falls ja, wie geht dies?
| >>
| >> Gruß - Heiner
| >>
| >>
| >> NS
| >> Wer Schreibfehler findet, darf sie ohne Nachfrage behalten.
| |
|
| Back to top |
|
|
Ken
Guest
|
| Posted: Sun Nov 18, 2007 4:15 pm Post subject: Re: Datum Format |
|
|
View with Formula displayed
A B C
View without Formula displayed
A B C
"Ken" <PleaseReply@NewsGroup.Thanks> wrote in message
news:eWS01FfKIHA.2268@TK2MSFTNGP02.phx.gbl...
| Translation from this web site.
|
| Übersetzung von dieser Web site.
|
| http://babelfish.altavista.com/tr
|
| Ken
|
| "Heiner Intzen" <Heinersein@t-online.de> wrote in message
| news:ee5XvceKIHA.4808@TK2MSFTNGP05.phx.gbl...
|
| Hello Ken, Only once thanks for your assistance and translation. Could you
| say to me please, with welchelm program you this translated? Greeting and
| glad work. Heiner
|
|
| | Hallo Ken,
| |
| | Erst einmal Danke für deine Hilfe und Übersetzung. Könntest du mir bitte
| | sagen, mit welchelm Programm hast du dies übersetzt?
| |
| | Gruß und frohes Schaffen.
| | Heiner
| |
| | "Ken" <PleaseReply@NewsGroup.Thanks> schrieb im Newsbeitrag
| | news:OGH67JVKIHA.4584@TK2MSFTNGP03.phx.gbl
| | > Translated.......
| | >
| | > Hello NG,
| | >
| | > However, unfortunately, mine is not in English so well I try,
| | > nevertheless once.
| | >
| | > If one can in Works-table calculation in 2000 change the date so:
| | >
| | > from 17.11.2007 after In such a way. 17.11.2007 or only in a cell A2
| | > as "In such a way"
| | > Cell B2 as "17.11.2007"
| | >
| | > If yes, how this goes?
| | >
| | > Greeting - Heiner
| | >
| | >
| | > NS
| | > Who finds write error, it may keep without inquiry.
| | >
| | > "Heiner Intzen" <Heinersein@t-online.de> wrote in message
| | > news:ucM2spTKIHA.5208@TK2MSFTNGP04.phx.gbl...
| | >> Hallo NG,
| | >>
| | >> Mein englisch ist leider nicht so gut aber ich versuche mich trotzdem
| | >> einmal.
| | >>
| | >> Kann man in Works-Tabellenkalkulation 2000, das Datum so ändern:
| | >>
| | >> von 17.11.2007 nach So. 17.11.2007 oder nur in einer Zelle A2 als
| | >> "So" Zelle B2 als "17.11.2007"
| | >>
| | >> Falls ja, wie geht dies?
| | >>
| | >> Gruß - Heiner
| | >>
| | >>
| | >> NS
| | >> Wer Schreibfehler findet, darf sie ohne Nachfrage behalten.
| |
| |
|
| Back to top |
|
|
Erik Jan
Guest
|
| Posted: Sun Nov 18, 2007 5:10 pm Post subject: Re: Datum Format |
|
|
Heiner Intzen had de volgende lumineuze gedachte op 18-11-07 14:30:
| Quote: | Hallo Erik Jan,
Yes thats rigth, but how can i do so?
Greatings from Hamburg Germany
Heiner
|
Look here.
Good Luck.
Erik Jan |
|
| Back to top |
|
|
Ken
Guest
|
| Posted: Sun Nov 18, 2007 5:40 pm Post subject: Re: Datum Format möglicherweise (perhaps) |
|
|
|
|
| Back to top |
|
|
Ken
Guest
|
| Posted: Sun Nov 18, 2007 5:46 pm Post subject: Re: Datum Format Formula |
|
|
=CHOOSE(MOD(B1,7),"Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday")
=CHOOSE(MOD(B14,7),"Samstag","Sonntag","Montag","Dienstag","Mittwoch","Donnerstag","Freitag") |
|
| Back to top |
|
|
Heiner Intzen
Guest
|
| Posted: Mon Nov 19, 2007 3:06 pm Post subject: Re: Datum Format |
|
|
Hello Erik Jan,
thanks for your collecting main, this was exactly which I searched.
Which I still search is a collecting main now after the following
sample.
A1 = 01.01.2007
A2 = Mo - weekday of 05.02.2007
B2 = 05.02.1941 - date of birth (05.02.1941Germany) (1941/02/05 USA)
thats me
C2 = "Heiner is " 66 "years old"
In Excel I do not have problems thereby, leave myself however not in
Works 2000 importing, it come error messages. Again thanks for your
assistance.
Kind regards - Heiner
"Erik Jan" <anonymous@discussions.microsoft.com> schrieb im Newsbeitrag
news:%23zDm1XgKIHA.3516@TK2MSFTNGP02.phx.gbl
| Quote: | Heiner Intzen had de volgende lumineuze gedachte op 18-11-07 14:30:
Hallo Erik Jan,
Yes thats rigth, but how can i do so?
Greatings from Hamburg Germany
Heiner
Look here.
Good Luck.
Erik Jan |
|
|
| Back to top |
|
|
Erik Jan
Guest
|
| Posted: Thu Nov 22, 2007 12:37 pm Post subject: Re: Datum Format |
|
|
Heiner Intzen had de volgende lumineuze gedachte op 19-11-07 16:06:
| Quote: | Hello Erik Jan,
thanks for your collecting main, this was exactly which I searched.
Which I still search is a collecting main now after the following sample.
A1 = 01.01.2007
A2 = Mo - weekday of 05.02.2007
B2 = 05.02.1941 - date of birth (05.02.1941Germany) (1941/02/05 USA)
thats me
C2 = "Heiner is " 66 "years old"
In Excel I do not have problems thereby, leave myself however not in
Works 2000 importing, it come error messages. Again thanks for your
assistance.
Kind regards - Heiner
|
Dear Heiner,
is this what you meant?
Greetings,
Erik Jan |
|
| Back to top |
|
|
Ken
Guest
|
| Posted: Thu Nov 22, 2007 3:39 pm Post subject: Re: Datum Format |
|
|
Hi Eric,
Attached is a AgeBorn spreadsheet made by Kevin.
Perhaps Heiner might find some of the formulas interesting.
Ken
"Erik Jan" <anonymous@discussions.microsoft.com> wrote in message
news:edLc9RQLIHA.5116@TK2MSFTNGP03.phx.gbl...
| Heiner Intzen had de volgende lumineuze gedachte op 19-11-07 16:06:
| > Hello Erik Jan,
| > thanks for your collecting main, this was exactly which I searched.
| > Which I still search is a collecting main now after the following
sample.
| > A1 = 01.01.2007
| > A2 = Mo - weekday of 05.02.2007
| > B2 = 05.02.1941 - date of birth (05.02.1941Germany) (1941/02/05 USA)
| > thats me
| > C2 = "Heiner is " 66 "years old"
| > In Excel I do not have problems thereby, leave myself however not in
| > Works 2000 importing, it come error messages. Again thanks for your
| > assistance.
| > Kind regards - Heiner
| >
|
| Dear Heiner,
|
| is this what you meant?
|
| Greetings,
|
| Erik Jan
| |
|
| Back to top |
|
|
Erik Jan
Guest
|
| Posted: Thu Nov 22, 2007 9:46 pm Post subject: Re: Datum Format |
|
|
Ken had de volgende lumineuze gedachte op 22-11-07 16:39:
| Quote: | Hi Eric,
Attached is a AgeBorn spreadsheet made by Kevin.
Perhaps Heiner might find some of the formulas interesting.
Ken
|
Dear Ken,
yes,m very nice. I did not know that Kevin had made this beautiful example.
Greetings,
Erik Jan. |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
