R
Roger PB
I work in German and in English, and am currently using Excel 2003, an
English version.
However, when trying to format dates, the formatting box comes up with
options using t,m,j (Tag, Monat, Jahr) rather than d,m,y. And the format
given for a serial date in an English book on VGA programming, ddddddd, just
does not work, even if translated to tttttt.
I believe that the language settings used by Excel are not actually accessed
from within the programme itself, but from somewhere else in Windows. But
where? And if I modify the settings, will my existing ones be modified
automatically or will I have to rewrite them all?
At any rate in older versions of Excel, the German macros used different
syntax from the English ones....
Roger PB
English version.
However, when trying to format dates, the formatting box comes up with
options using t,m,j (Tag, Monat, Jahr) rather than d,m,y. And the format
given for a serial date in an English book on VGA programming, ddddddd, just
does not work, even if translated to tttttt.
I believe that the language settings used by Excel are not actually accessed
from within the programme itself, but from somewhere else in Windows. But
where? And if I modify the settings, will my existing ones be modified
automatically or will I have to rewrite them all?
At any rate in older versions of Excel, the German macros used different
syntax from the English ones....
Roger PB