Day and language fomat
 

Hello,

A1:= "monday" and not "Monday"
By formatting the A1 Cell: Format/Cell/number/custom:dddd

First: This displays "lundi" instead of "Lundi"
Second: How about if I would like "Monday" in English and not in French, in
other words: "Monday" and not "Lundi".

Thanks very much for helping me
Tom

Day and language fomat
 

See this site: http://support.microsoft.com/kb/177561/

"Tom" wrote:

Hello,

A1:= "monday" and not "Monday"
By formatting the A1 Cell: Format/Cell/number/custom:dddd

First: This displays "lundi" instead of "Lundi"
Second: How about if I would like "Monday" in English and not in French, in
other words: "Monday" and not "Lundi".

Thanks very much for helping me
Tom

Day and language fomat
 

Hi Tom

Try, in B1,
=TEXT(A1,"[$-409]dddd")
works in newer Excel versions only.

HTH. Best wishes Harald

"Tom" skrev i melding
...
Hello,

A1:= "monday" and not "Monday"
By formatting the A1 Cell: Format/Cell/number/custom:dddd

First: This displays "lundi" instead of "Lundi"
Second: How about if I would like "Monday" in English and not in French,
in
other words: "Monday" and not "Lundi".

Thanks very much for helping me
Tom